{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["APU Profile Form","checklist","Roster","APU Master","FY23-FY24 Scales","APU Scale"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":9,"defined_names":129,"comments":3,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"APU Profile Form","index":0,"n_rows":178,"n_cols":14,"rows_kept":178,"cut":false,"hidden":false,"merged":[[2,3,2,8],[4,3,4,8],[6,3,6,8],[8,3,8,8],[11,2,19,10]]}
[]
[]
[null,null,"DEPARTMENT:"]
[]
[null,null,"APU NAME:"]
[]
[null,null,"APU CODE:"]
[]
[null,null,"DATE SUBMITTED:",{"$f":"TODAY()","v":"2024-10-04"}]
[]
[null,null,"Description of APU:  Please include criteria used."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"PROPOSED HEALTH SCIENCES SALARY SCALE:"]
[null,null,"(Using Scale pay numbers: 1 thru 9. Insert Scale pay number assigned to APU for each of 5 future years.)"]
[]
[null,null,null,"2024-07-01",null,"2025-07-01",{"$f":"E25","v":0},"2026-07-01",{"$f":"G25","v":0}]
[]
[null,null,null,"2027-07-01",{"$f":"I25","v":0},"2028-07-01",{"$f":"E27","v":0}]
[]
[]
[]
[null,null,"APU Membership:"]
[null,null,"(Use current established Scale Pay rates at the time of the submission. DO NOT USE blended FY pay rates. Attach another sheet if necessary.)"]
[]
[null,null,null,null,null,"X Salary","X' Salary","Off-Scale Salary","Total Covered Comp","Y Salary","Total Negotiated"]
[null,null,"Name","Rank","Step","Annual Rate","Annual Rate","Annual Rate","Annual Rate","Annual Rate","Annual Rate",null,"X","X'"]
[null,null,null,null,null,null,null,null,{"$f":"F36+G36+H36","v":0},null,{"$f":"I36+J36","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"F37+G37+H37","v":0},null,{"$f":"I37+J37","v":0},null,193800,19400]
[null,null,null,null,null,null,null,null,0,null,0,null,166300,16600]
[null,null,null,null,null,null,null,null,0,null,0,null,133900,13400]
[null,null,null,null,null,null,null,null,0,null,0,null,108900,10900]
[null,null,null,null,null,null,null,null,0,null,0,null,108900,10900]
[null,null,null,null,null,null,null,null,0,null,0,null,88300,8800]
[null,null,null,null,null,null,null,null,0,null,0,null,88300,8800]
[null,null,null,null,null,null,null,null,0,null,0,null,88300,8800]
[null,null,null,null,null,null,null,null,0,null,0,null,108900,10900]
[null,null,null,null,null,null,null,null,0,null,0,null,88300,8800]
[null,null,null,null,null,null,null,null,0,null,0,null,88300,8800]
[null,null,null,null,null,null,null,null,0,null,0,null,88300,8800]
[null,null,null,null,null,null,null,null,0,null,0,null,98500,9900]
[null,null,null,null,null,null,null,null,0,null,0,null,143900,14400]
[null,null,null,null,null,null,null,null,0,null,0,null,103600,10400]
[null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,0,null,0,null,193800,19400]
[null,null,null,null,null,null,null,null,0,null,0,null,166300,16600]
[null,null,null,null,null,null,null,null,0,null,0,null,133900,13400]
[null,null,null,null,null,null,null,null,0,null,0,null,108900,10900]
[null,null,null,null,null,null,null,null,0,null,0,null,108900,10900]
[null,null,null,null,null,null,null,null,0,null,0,null,88300,8800]
[null,null,null,null,null,null,null,null,0,null,0,null,88300,8800]
[null,null,null,null,null,null,null,null,0,null,0,null,88300,8800]
[null,null,null,null,null,null,null,null,0,null,0,null,108900,10900]
[null,null,null,null,null,null,null,null,0,null,0,null,88300,8800]
[null,null,null,null,null,null,null,null,0,null,0,null,88300,8800]
[null,null,null,null,null,null,null,null,0,null,0,null,88300,8800]
[null,null,null,null,null,null,null,null,0,null,0,null,88300,8800]
[null,null,null,null,null,null,null,null,0,null,0,null,88300,8800]
[null,null,null,null,null,null,null,null,0,null,0,null,88300,8800]
[null,null,null,null,null,null,null,null,0,null,0,null,88300,8800]
[null,null,null,null,null,null,null,null,0,null,0,null,88300,8800]
[null,null,null,null,null,null,null,null,0,null,0,null,88300,8800]
[null,null,null,null,null,null,null,null,0,null,0,null,88300,8800]
[null,null,null,null,null,null,null,null,0,null,0,null,88300,8800]
[null,null,null,null,null,null,null,null,0,null,0,null,88300,8800]
[null,null,null,null,null,null,null,null,0,null,0,null,88300,8800]
[null,null,null,null,null,null,null,null,0,null,0,null,88300,8800]
[null,null,null,null,null,null,null,null,0,null,0,null,88300,8800]
[null,null,null,null,null,null,null,null,0,null,0,null,88300,8800]
[null,null,null,null,null,null,null,null,0,null,0,null,88300,8800]
[null,null,null,null,null,null,null,null,0,null,0,null,88300,8800]
[null,null,null,null,null,null,null,null,0,null,0,null,88300,8800]
[null,null,null,null,null,null,null,null,0,null,0,null,88300,8800]
[null,null,null,null,null,null,null,null,0,null,0,null,88300,8800]
[null,null,null,null,null,null,null,null,0,null,0,null,88300,8800]
[null,null,null,null,null,null,null,null,0,null,0,null,88300,8800]
[null,null,null,null,null,null,null,null,0,null,0,null,88300,8800]
[null,null,null,null,null,null,null,null,0,null,0,null,88300,8800]
[null,null,null,null,null,null,null,null,0,null,0,null,88300,8800]
[null,null,null,null,null,null,null,null,0,null,0,null,88300,8800]
[null,null,null,null,null,null,null,null,0,null,0,null,88300,8800]
[null,null,null,null,null,null,null,null,0,null,0,null,88300,8800]
[null,null,null,null,null,null,null,null,0,null,0,null,88300,8800]
[null,null,null,null,null,null,null,null,0,null,0,null,88300,8800]
[null,null,null,null,null,null,null,null,0,null,0,null,88300,8800]
[null,null,null,null,null,null,null,null,0,null,0,null,88300,8800]
[null,null,null,null,null,null,null,null,0,null,0,null,88300,8800]
[null,null,null,null,null,null,null,null,0,null,0,null,88300,8800]
[null,null,null,null,null,null,null,null,0,null,0,null,88300,8800]
[null,null,null,null,null,null,null,null,0,null,0,null,88300,8800]
[null,null,null,null,null,null,null,null,0,null,0,null,88300,8800]
[null,null,null,null,null,null,null,null,{"$f":"F101+G101+H101","v":0},null,{"$f":"I101+J101","v":0},null,88300,8800]
[null,null,null,null,null,null,null,null,0,null,0,null,88300,8800]
[null,null,null,null,null,null,null,null,0,null,0,null,88300,8800]
[null,null,null,null,null,null,null,null,0,null,0,null,88300,8800]
[null,null,null,null,null,null,null,null,0,null,0,null,88300,8800]
[null,null,null,null,null,null,null,null,0,null,0,null,88300,8800]
[null,null,null,null,null,null,null,null,0,null,0,null,88300,8800]
[null,null,null,null,null,null,null,null,0,null,0,null,88300,8800]
[null,null,null,null,null,null,null,null,0,null,0,null,88300,8800]
[null,null,null,null,null,null,null,null,0,null,0,null,88300,8800]
[null,null,null,null,null,null,null,null,0,null,0,null,88300,8800]
[null,null,null,null,null,null,null,null,0,null,0,null,88300,8800]
[null,null,null,null,null,null,null,null,0,null,0,null,88300,8800]
[null,null,null,null,null,null,null,null,0,null,0,null,88300,8800]
[null,null,null,null,null,null,null,null,0,null,0,null,88300,8800]
[null,null,null,null,null,null,null,null,0,null,0,null,88300,8800]
[null,null,null,null,null,null,null,null,0,null,0,null,88300,8800]
[null,null,null,null,null,null,null,null,0,null,0,null,88300,8800]
[null,null,null,null,null,null,null,null,0,null,0,null,88300,8800]
[null,null,null,null,null,null,null,null,0,null,0,null,88300,8800]
[null,null,null,null,null,null,null,null,0,null,0,null,88300,8800]
[null,null,null,null,null,null,null,null,0,null,0,null,88300,8800]
[null,null,null,null,null,null,null,null,0,null,0,null,88300,8800]
[null,null,null,null,null,null,null,null,0,null,0,null,88300,8800]
[null,null,null,null,null,null,null,null,0,null,0,null,88300,8800]
[null,null,null,null,null,null,null,null,0,null,0,null,88300,8800]
[null,null,null,null,null,null,null,null,0,null,0,null,88300,8800]
[null,null,null,null,null,null,null,null,0,null,0,null,88300,8800]
[null,null,null,null,null,null,null,null,0,null,0,null,88300,8800]
[null,null,null,null,null,null,null,null,0,null,0,null,88300,8800]
[null,null,null,null,null,null,null,null,0,null,0,null,88300,8800]
[null,null,null,null,null,null,null,null,0,null,0,null,88300,8800]
[null,null,null,null,null,null,null,null,0,null,0,null,88300,8800]
[null,null,null,null,null,null,null,null,0,null,0,null,88300,8800]
[null,null,null,null,null,null,null,null,0,null,0,null,88300,8800]
[null,null,null,null,null,null,null,null,0,null,0,null,88300,8800]
[null,null,null,null,null,null,null,null,0,null,0,null,88300,8800]
[null,null,null,null,null,null,null,null,0,null,0,null,88300,8800]
[null,null,null,null,null,null,null,null,0,null,0,null,88300,8800]
[null,null,null,null,null,null,null,null,0,null,0,null,88300,8800]
[null,null,null,null,null,null,null,null,0,null,0,null,88300,8800]
[null,null,null,null,null,null,null,null,0,null,0,null,88300,8800]
[null,null,null,null,null,null,null,null,0,null,0,null,88300,8800]
[null,null,null,null,null,null,null,null,0,null,0,null,88300,8800]
[null,null,null,null,null,null,null,null,0,null,0,null,88300,8800]
[null,null,null,null,null,null,null,null,0,null,0,null,88300,8800]
[null,null,null,null,null,null,null,null,0,null,0,null,88300,8800]
[null,null,null,null,null,null,null,null,0,null,0,null,88300,8800]
[null,null,null,null,null,null,null,null,0,null,0,null,88300,8800]
[null,null,null,null,null,null,null,null,0,null,0,null,88300,8800]
[null,null,null,null,null,null,null,null,0,null,0,null,88300,8800]
[null,null,null,null,null,null,null,null,0,null,0,null,88300,8800]
[null,null,null,null,null,null,null,null,0,null,0,null,88300,8800]
[null,null,null,null,null,null,null,null,0,null,0,null,88300,8800]
[null,null,null,null,null,null,null,null,0,null,0,null,88300,8800]
[null,null,null,null,null,null,null,null,0,null,0,null,88300,8800]
[null,null,null,null,null,null,null,null,0,null,0,null,88300,8800]
[null,null,null,null,null,null,null,null,0,null,0,null,88300,8800]
[null,null,null,null,null,null,null,null,0,null,0,null,88300,8800]
[null,null,null,null,null,null,null,null,0,null,0,null,88300,8800]
[null,null,null,null,null,null,null,null,0,null,0,null,88300,8800]
[null,null,null,null,null,null,null,null,0,null,0,null,88300,8800]
[null,null,null,null,null,null,null,null,0,null,0,null,88300,8800]
[null,null,null,null,null,null,null,null,0,null,0,null,88300,8800]
[null,null,null,null,null,null,null,null,{"$f":"F165+G165+H165","v":0},null,{"$f":"I165+J165","v":0},null,88300,8800]
[]
[null,null,"APPROVALS:"]
[]
[null,null,"AVC/DBO",null,null,null,null,null,"Date"]
[]
[null,null,"Department Chair",null,null,null,null,null,"Date"]
[]
[null,null,"VCHS/Dean",null,null,null,null,null,"Date"]
[]
[null,null,"Other",null,null,null,null,null,"Date"]
[]
[]
[null,null,"This form is routed to Han Ho (h3ho@health.ucsd.edu) or ARCrequest@health.ucsd.edu prior to submission to the Dean."]

{"sheet":"checklist","index":1,"n_rows":19,"n_cols":2,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Checklist to review before sending for Dean's or VC's approval:"]
[]
[]
["APU profile form:"]
[null,"add all Faculty that belong to the code (including all the new Faculty appointments started during the current/prior FY)"]
[null,"remove all Faculty that no longer belong to the code"]
[null,"make sure all salary are based on the current, approved rank, step, and HSCP salary scales (do not use projected info)"]
[null,"* if APU scale is being changed for the APU code -> calculate the X', offscale, and Y based on the changed APU scale for ALL Faculty being listed"]
[null,"* if Faculty is being added to the APU code  -> calculate the X', offscale, and Y based on the changed APU scale for the newly added Faculty only"]
[null,"review to see if any APU code has fewer than 5 members, if so, this will be a compliance issue and department will need to provide justification in the memo to ask for the exceptional approval "]
[]
[]
["Chair's memo needs to include the following info:"]
[null,"list of all the changes being requested"]
[null,"justification for the requested changes"]
[null,"confirmation that all APU members are in good standing"]
[null,"confirmation that the department accepts 415(m) liability that may result"]
[null,"confirmation that the APU will be able to maintain the covered compensation rate for at least 3 years"]
[null,"if any APU code has fewer than 5 members, need to provide justification in the memo to ask for the exceptional approval "]

{"sheet":"Roster","index":2,"n_rows":139,"n_cols":16,"rows_kept":139,"cut":false,"hidden":true,"merged":[[7,10,7,14],[7,0,7,1],[7,2,7,9]]}
["I N S T R U C T I O N S :"]
["1. Click the",null,"button on the Roster tab, to clear existing data and prepare the form for entry.",null,null,null,null,null,"6. Paste Values (V) into the section highlighted yellow below (starting in Cell C10)."]
["2. In ARC ServiceNow, go to ARC Report Library > Compensation Reports > APU Profile Form.",null,null,null,null,null,null,null,"7. Type in the APU Code in Cell A10 and the APU Scale in Cell B10 (highlighted orange)."]
["3. In the APU Name Search box, type in the desired APU Code and hit Enter.",null,null,null,null,null,null,null,"7. Delete employees moving out of the APU and add employees moving into the APU."]
["4. Right click anywhere in the headers, go to the Export menu and select Excel (.xlsx).",null,null,null,null,null,null,null,"8. Sort Column D (AIR Profile) A to Z, so faculty members appear in alphabetical order."]
["5. Copy all data from the exported spreadsheet in Column C through Column J, starting at Row 2.",null,null,null,null,null,null,null,"10. On the APU Profile Form, hide all the blank linges and highlight the rows with new faculty."]
[]
["MANUAL  -  MANUAL",null,"A I R E L    -    A I R E L    -    A I R E L    -    A I R E L    -    A I R E L    -    A I R E L    -    A I R E L    -   A I R E L    -    A I R E L",null,null,null,null,null,null,null,"CALCULATED   -   CALCULATED   -   CALCULATED   -   CALCULATED"]
["APU Code","APU Scale","Department","AIR Profile","Rank","Step","Base (X)","Off Scale X","Total Negotiated (100%)","Stipend","Base (X)","X'","Total Off-Scale (X+X')","Total Covered Comp","Y","RankStepScale"]
["ORT001",6,"ORTHOPAEDIC SURGERY","Allen, Richard","Full","II",135400,0,300000,0,{"$f":"IFERROR(VLOOKUP(P10,'FY23-FY24 Scales'!A:J,10,FALSE),G10)","v":135400},{"$f":"IFERROR(VLOOKUP(P10,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G10*VLOOKUP(B10*1,'APU Scale'!A:B,2,FALSE)-G10,-2))","v":88100},{"$f":"ROUND(H10*VLOOKUP(B10*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},{"$f":"K10+L10+M10","v":223500},{"$f":"IF(I10-J10-N10<0,0,I10-J10-N10)","v":76500},{"$f":"CONCATENATE(E10,F10,B10)","v":"FullII6"}]
[{"$f":"A10","v":"ORT001"},{"$f":"B10","v":6},"ORTHOPAEDIC SURGERY","Blais, Micah","Assistant","II",91300,0,150700,0,{"$f":"IFERROR(VLOOKUP(P11,'FY23-FY24 Scales'!A:J,10,FALSE),G11)","v":91300},{"$f":"IFERROR(VLOOKUP(P11,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G11*VLOOKUP(B11*1,'APU Scale'!A:B,2,FALSE)-G11,-2))","v":59400},{"$f":"ROUND(H11*VLOOKUP(B11*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},150700,0,"AssistantII6"]
["ORT001",6,"ORTHOPAEDIC SURGERY","Chiarappa, Frank","Assistant","IV",101700,0,212100,0,{"$f":"IFERROR(VLOOKUP(P12,'FY23-FY24 Scales'!A:J,10,FALSE),G12)","v":101700},{"$f":"IFERROR(VLOOKUP(P12,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G12*VLOOKUP(B12*1,'APU Scale'!A:B,2,FALSE)-G12,-2))","v":66200},{"$f":"ROUND(H12*VLOOKUP(B12*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},167900,44200,"AssistantIV6"]
["ORT001",6,"ORTHOPAEDIC SURGERY","Foran, Ian","Assistant","III",96400,0,212100,0,{"$f":"IFERROR(VLOOKUP(P13,'FY23-FY24 Scales'!A:J,10,FALSE),G13)","v":96400},{"$f":"IFERROR(VLOOKUP(P13,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G13*VLOOKUP(B13*1,'APU Scale'!A:B,2,FALSE)-G13,-2))","v":62700},{"$f":"ROUND(H13*VLOOKUP(B13*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},159100,53000,"AssistantIII6"]
["ORT001",6,"ORTHOPAEDIC SURGERY","Girard, Paul","Full","II",135400,0,223500,0,{"$f":"IFERROR(VLOOKUP(P14,'FY23-FY24 Scales'!A:J,10,FALSE),G14)","v":135400},{"$f":"IFERROR(VLOOKUP(P14,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G14*VLOOKUP(B14*1,'APU Scale'!A:B,2,FALSE)-G14,-2))","v":88100},{"$f":"ROUND(H14*VLOOKUP(B14*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},223500,0,"FullII6"]
["ORT001",6,"ORTHOPAEDIC SURGERY","Gonzales, Francis","Full","I",125700,0,212100,0,{"$f":"IFERROR(VLOOKUP(P15,'FY23-FY24 Scales'!A:J,10,FALSE),G15)","v":125700},{"$f":"IFERROR(VLOOKUP(P15,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G15*VLOOKUP(B15*1,'APU Scale'!A:B,2,FALSE)-G15,-2))","v":81800},{"$f":"ROUND(H15*VLOOKUP(B15*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},207500,4600,"FullI6"]
["ORT001",6,"ORTHOPAEDIC SURGERY","Hentzen, Eric","Full","II",135400,0,223500,0,{"$f":"IFERROR(VLOOKUP(P16,'FY23-FY24 Scales'!A:J,10,FALSE),G16)","v":135400},{"$f":"IFERROR(VLOOKUP(P16,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G16*VLOOKUP(B16*1,'APU Scale'!A:B,2,FALSE)-G16,-2))","v":88100},{"$f":"ROUND(H16*VLOOKUP(B16*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},223500,0,"FullII6"]
["ORT001",6,"ORTHOPAEDIC SURGERY","Kent, William","Associate","I",107300,0,212100,0,{"$f":"IFERROR(VLOOKUP(P17,'FY23-FY24 Scales'!A:J,10,FALSE),G17)","v":107300},{"$f":"IFERROR(VLOOKUP(P17,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G17*VLOOKUP(B17*1,'APU Scale'!A:B,2,FALSE)-G17,-2))","v":69800},{"$f":"ROUND(H17*VLOOKUP(B17*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},177100,35000,"AssociateI6"]
["ORT001",6,"ORTHOPAEDIC SURGERY","Leek, Bryan","Associate","IV",125600,0,212100,0,{"$f":"IFERROR(VLOOKUP(P18,'FY23-FY24 Scales'!A:J,10,FALSE),G18)","v":125600},{"$f":"IFERROR(VLOOKUP(P18,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G18*VLOOKUP(B18*1,'APU Scale'!A:B,2,FALSE)-G18,-2))","v":81800},{"$f":"ROUND(H18*VLOOKUP(B18*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},207400,4700,"AssociateIV6"]
["ORT001",6,"ORTHOPAEDIC SURGERY","Mitchell, Joseph","Assistant","III",96400,0,212100,0,{"$f":"IFERROR(VLOOKUP(P19,'FY23-FY24 Scales'!A:J,10,FALSE),G19)","v":96400},{"$f":"IFERROR(VLOOKUP(P19,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G19*VLOOKUP(B19*1,'APU Scale'!A:B,2,FALSE)-G19,-2))","v":62700},{"$f":"ROUND(H19*VLOOKUP(B19*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},159100,53000,"AssistantIII6"]
["ORT001",6,"ORTHOPAEDIC SURGERY","O'leary, Ryan","Assistant","II",91300,0,212100,0,{"$f":"IFERROR(VLOOKUP(P20,'FY23-FY24 Scales'!A:J,10,FALSE),G20)","v":91300},{"$f":"IFERROR(VLOOKUP(P20,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G20*VLOOKUP(B20*1,'APU Scale'!A:B,2,FALSE)-G20,-2))","v":59400},{"$f":"ROUND(H20*VLOOKUP(B20*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},150700,61400,"AssistantII6"]
["ORT001",6,"ORTHOPAEDIC SURGERY","Robertson, Catherine","Full","I",125700,0,212100,0,{"$f":"IFERROR(VLOOKUP(P21,'FY23-FY24 Scales'!A:J,10,FALSE),G21)","v":125700},{"$f":"IFERROR(VLOOKUP(P21,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G21*VLOOKUP(B21*1,'APU Scale'!A:B,2,FALSE)-G21,-2))","v":81800},{"$f":"ROUND(H21*VLOOKUP(B21*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},207500,4600,"FullI6"]
["ORT001",6,"ORTHOPAEDIC SURGERY","Sullivan, Thomas","Assistant","III",96400,0,212100,0,{"$f":"IFERROR(VLOOKUP(P22,'FY23-FY24 Scales'!A:J,10,FALSE),G22)","v":96400},{"$f":"IFERROR(VLOOKUP(P22,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G22*VLOOKUP(B22*1,'APU Scale'!A:B,2,FALSE)-G22,-2))","v":62700},{"$f":"ROUND(H22*VLOOKUP(B22*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},159100,53000,"AssistantIII6"]
["ORT001",6,"ORTHOPAEDIC SURGERY","Zlomislic, Vinko","Associate","III",118900,0,212100,0,{"$f":"IFERROR(VLOOKUP(P23,'FY23-FY24 Scales'!A:J,10,FALSE),G23)","v":118900},{"$f":"IFERROR(VLOOKUP(P23,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G23*VLOOKUP(B23*1,'APU Scale'!A:B,2,FALSE)-G23,-2))","v":77300},{"$f":"ROUND(H23*VLOOKUP(B23*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},196200,15900,"AssociateIII6"]
["ORT001",6,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P24,'FY23-FY24 Scales'!A:J,10,FALSE),G24)","v":0},{"$f":"IFERROR(VLOOKUP(P24,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G24*VLOOKUP(B24*1,'APU Scale'!A:B,2,FALSE)-G24,-2))","v":0},{"$f":"ROUND(H24*VLOOKUP(B24*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"6"]
["ORT001",6,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P25,'FY23-FY24 Scales'!A:J,10,FALSE),G25)","v":0},{"$f":"IFERROR(VLOOKUP(P25,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G25*VLOOKUP(B25*1,'APU Scale'!A:B,2,FALSE)-G25,-2))","v":0},{"$f":"ROUND(H25*VLOOKUP(B25*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"6"]
["ORT001",6,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P26,'FY23-FY24 Scales'!A:J,10,FALSE),G26)","v":0},{"$f":"IFERROR(VLOOKUP(P26,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G26*VLOOKUP(B26*1,'APU Scale'!A:B,2,FALSE)-G26,-2))","v":0},{"$f":"ROUND(H26*VLOOKUP(B26*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"6"]
["ORT001",6,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P27,'FY23-FY24 Scales'!A:J,10,FALSE),G27)","v":0},{"$f":"IFERROR(VLOOKUP(P27,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G27*VLOOKUP(B27*1,'APU Scale'!A:B,2,FALSE)-G27,-2))","v":0},{"$f":"ROUND(H27*VLOOKUP(B27*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"6"]
["ORT001",6,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P28,'FY23-FY24 Scales'!A:J,10,FALSE),G28)","v":0},{"$f":"IFERROR(VLOOKUP(P28,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G28*VLOOKUP(B28*1,'APU Scale'!A:B,2,FALSE)-G28,-2))","v":0},{"$f":"ROUND(H28*VLOOKUP(B28*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"6"]
["ORT001",6,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P29,'FY23-FY24 Scales'!A:J,10,FALSE),G29)","v":0},{"$f":"IFERROR(VLOOKUP(P29,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G29*VLOOKUP(B29*1,'APU Scale'!A:B,2,FALSE)-G29,-2))","v":0},{"$f":"ROUND(H29*VLOOKUP(B29*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"6"]
["ORT001",6,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P30,'FY23-FY24 Scales'!A:J,10,FALSE),G30)","v":0},{"$f":"IFERROR(VLOOKUP(P30,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G30*VLOOKUP(B30*1,'APU Scale'!A:B,2,FALSE)-G30,-2))","v":0},{"$f":"ROUND(H30*VLOOKUP(B30*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"6"]
["ORT001",6,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P31,'FY23-FY24 Scales'!A:J,10,FALSE),G31)","v":0},{"$f":"IFERROR(VLOOKUP(P31,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G31*VLOOKUP(B31*1,'APU Scale'!A:B,2,FALSE)-G31,-2))","v":0},{"$f":"ROUND(H31*VLOOKUP(B31*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"6"]
["ORT001",6,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P32,'FY23-FY24 Scales'!A:J,10,FALSE),G32)","v":0},{"$f":"IFERROR(VLOOKUP(P32,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G32*VLOOKUP(B32*1,'APU Scale'!A:B,2,FALSE)-G32,-2))","v":0},{"$f":"ROUND(H32*VLOOKUP(B32*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"6"]
["ORT001",6,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P33,'FY23-FY24 Scales'!A:J,10,FALSE),G33)","v":0},{"$f":"IFERROR(VLOOKUP(P33,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G33*VLOOKUP(B33*1,'APU Scale'!A:B,2,FALSE)-G33,-2))","v":0},{"$f":"ROUND(H33*VLOOKUP(B33*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"6"]
["ORT001",6,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P34,'FY23-FY24 Scales'!A:J,10,FALSE),G34)","v":0},{"$f":"IFERROR(VLOOKUP(P34,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G34*VLOOKUP(B34*1,'APU Scale'!A:B,2,FALSE)-G34,-2))","v":0},{"$f":"ROUND(H34*VLOOKUP(B34*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"6"]
["ORT001",6,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P35,'FY23-FY24 Scales'!A:J,10,FALSE),G35)","v":0},{"$f":"IFERROR(VLOOKUP(P35,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G35*VLOOKUP(B35*1,'APU Scale'!A:B,2,FALSE)-G35,-2))","v":0},{"$f":"ROUND(H35*VLOOKUP(B35*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"6"]
["ORT001",6,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P36,'FY23-FY24 Scales'!A:J,10,FALSE),G36)","v":0},{"$f":"IFERROR(VLOOKUP(P36,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G36*VLOOKUP(B36*1,'APU Scale'!A:B,2,FALSE)-G36,-2))","v":0},{"$f":"ROUND(H36*VLOOKUP(B36*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"6"]
["ORT001",6,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P37,'FY23-FY24 Scales'!A:J,10,FALSE),G37)","v":0},{"$f":"IFERROR(VLOOKUP(P37,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G37*VLOOKUP(B37*1,'APU Scale'!A:B,2,FALSE)-G37,-2))","v":0},{"$f":"ROUND(H37*VLOOKUP(B37*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"6"]
["ORT001",6,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P38,'FY23-FY24 Scales'!A:J,10,FALSE),G38)","v":0},{"$f":"IFERROR(VLOOKUP(P38,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G38*VLOOKUP(B38*1,'APU Scale'!A:B,2,FALSE)-G38,-2))","v":0},{"$f":"ROUND(H38*VLOOKUP(B38*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"6"]
["ORT001",6,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P39,'FY23-FY24 Scales'!A:J,10,FALSE),G39)","v":0},{"$f":"IFERROR(VLOOKUP(P39,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G39*VLOOKUP(B39*1,'APU Scale'!A:B,2,FALSE)-G39,-2))","v":0},{"$f":"ROUND(H39*VLOOKUP(B39*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"6"]
["ORT001",6,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P40,'FY23-FY24 Scales'!A:J,10,FALSE),G40)","v":0},{"$f":"IFERROR(VLOOKUP(P40,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G40*VLOOKUP(B40*1,'APU Scale'!A:B,2,FALSE)-G40,-2))","v":0},{"$f":"ROUND(H40*VLOOKUP(B40*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"6"]
["ORT001",6,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P41,'FY23-FY24 Scales'!A:J,10,FALSE),G41)","v":0},{"$f":"IFERROR(VLOOKUP(P41,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G41*VLOOKUP(B41*1,'APU Scale'!A:B,2,FALSE)-G41,-2))","v":0},{"$f":"ROUND(H41*VLOOKUP(B41*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"6"]
["ORT001",6,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P42,'FY23-FY24 Scales'!A:J,10,FALSE),G42)","v":0},{"$f":"IFERROR(VLOOKUP(P42,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G42*VLOOKUP(B42*1,'APU Scale'!A:B,2,FALSE)-G42,-2))","v":0},{"$f":"ROUND(H42*VLOOKUP(B42*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},{"$f":"K42+L42+M42","v":0},{"$f":"IF(I42-J42-N42<0,0,I42-J42-N42)","v":0},{"$f":"CONCATENATE(E42,F42,B42)","v":"6"}]
[{"$f":"A42","v":"ORT001"},{"$f":"B42","v":6},null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P43,'FY23-FY24 Scales'!A:J,10,FALSE),G43)","v":0},{"$f":"IFERROR(VLOOKUP(P43,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G43*VLOOKUP(B43*1,'APU Scale'!A:B,2,FALSE)-G43,-2))","v":0},{"$f":"ROUND(H43*VLOOKUP(B43*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"6"]
["ORT001",6,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P44,'FY23-FY24 Scales'!A:J,10,FALSE),G44)","v":0},{"$f":"IFERROR(VLOOKUP(P44,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G44*VLOOKUP(B44*1,'APU Scale'!A:B,2,FALSE)-G44,-2))","v":0},{"$f":"ROUND(H44*VLOOKUP(B44*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"6"]
["ORT001",6,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P45,'FY23-FY24 Scales'!A:J,10,FALSE),G45)","v":0},{"$f":"IFERROR(VLOOKUP(P45,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G45*VLOOKUP(B45*1,'APU Scale'!A:B,2,FALSE)-G45,-2))","v":0},{"$f":"ROUND(H45*VLOOKUP(B45*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"6"]
["ORT001",6,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P46,'FY23-FY24 Scales'!A:J,10,FALSE),G46)","v":0},{"$f":"IFERROR(VLOOKUP(P46,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G46*VLOOKUP(B46*1,'APU Scale'!A:B,2,FALSE)-G46,-2))","v":0},{"$f":"ROUND(H46*VLOOKUP(B46*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"6"]
["ORT001",6,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P47,'FY23-FY24 Scales'!A:J,10,FALSE),G47)","v":0},{"$f":"IFERROR(VLOOKUP(P47,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G47*VLOOKUP(B47*1,'APU Scale'!A:B,2,FALSE)-G47,-2))","v":0},{"$f":"ROUND(H47*VLOOKUP(B47*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"6"]
["ORT001",6,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P48,'FY23-FY24 Scales'!A:J,10,FALSE),G48)","v":0},{"$f":"IFERROR(VLOOKUP(P48,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G48*VLOOKUP(B48*1,'APU Scale'!A:B,2,FALSE)-G48,-2))","v":0},{"$f":"ROUND(H48*VLOOKUP(B48*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"6"]
["ORT001",6,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P49,'FY23-FY24 Scales'!A:J,10,FALSE),G49)","v":0},{"$f":"IFERROR(VLOOKUP(P49,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G49*VLOOKUP(B49*1,'APU Scale'!A:B,2,FALSE)-G49,-2))","v":0},{"$f":"ROUND(H49*VLOOKUP(B49*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"6"]
["ORT001",6,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P50,'FY23-FY24 Scales'!A:J,10,FALSE),G50)","v":0},{"$f":"IFERROR(VLOOKUP(P50,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G50*VLOOKUP(B50*1,'APU Scale'!A:B,2,FALSE)-G50,-2))","v":0},{"$f":"ROUND(H50*VLOOKUP(B50*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"6"]
["ORT001",6,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P51,'FY23-FY24 Scales'!A:J,10,FALSE),G51)","v":0},{"$f":"IFERROR(VLOOKUP(P51,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G51*VLOOKUP(B51*1,'APU Scale'!A:B,2,FALSE)-G51,-2))","v":0},{"$f":"ROUND(H51*VLOOKUP(B51*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"6"]
["ORT001",6,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P52,'FY23-FY24 Scales'!A:J,10,FALSE),G52)","v":0},{"$f":"IFERROR(VLOOKUP(P52,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G52*VLOOKUP(B52*1,'APU Scale'!A:B,2,FALSE)-G52,-2))","v":0},{"$f":"ROUND(H52*VLOOKUP(B52*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"6"]
["ORT001",6,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P53,'FY23-FY24 Scales'!A:J,10,FALSE),G53)","v":0},{"$f":"IFERROR(VLOOKUP(P53,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G53*VLOOKUP(B53*1,'APU Scale'!A:B,2,FALSE)-G53,-2))","v":0},{"$f":"ROUND(H53*VLOOKUP(B53*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"6"]
["ORT001",6,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P54,'FY23-FY24 Scales'!A:J,10,FALSE),G54)","v":0},{"$f":"IFERROR(VLOOKUP(P54,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G54*VLOOKUP(B54*1,'APU Scale'!A:B,2,FALSE)-G54,-2))","v":0},{"$f":"ROUND(H54*VLOOKUP(B54*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"6"]
["ORT001",6,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P55,'FY23-FY24 Scales'!A:J,10,FALSE),G55)","v":0},{"$f":"IFERROR(VLOOKUP(P55,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G55*VLOOKUP(B55*1,'APU Scale'!A:B,2,FALSE)-G55,-2))","v":0},{"$f":"ROUND(H55*VLOOKUP(B55*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"6"]
["ORT001",6,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P56,'FY23-FY24 Scales'!A:J,10,FALSE),G56)","v":0},{"$f":"IFERROR(VLOOKUP(P56,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G56*VLOOKUP(B56*1,'APU Scale'!A:B,2,FALSE)-G56,-2))","v":0},{"$f":"ROUND(H56*VLOOKUP(B56*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"6"]
["ORT001",6,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P57,'FY23-FY24 Scales'!A:J,10,FALSE),G57)","v":0},{"$f":"IFERROR(VLOOKUP(P57,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G57*VLOOKUP(B57*1,'APU Scale'!A:B,2,FALSE)-G57,-2))","v":0},{"$f":"ROUND(H57*VLOOKUP(B57*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"6"]
["ORT001",6,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P58,'FY23-FY24 Scales'!A:J,10,FALSE),G58)","v":0},{"$f":"IFERROR(VLOOKUP(P58,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G58*VLOOKUP(B58*1,'APU Scale'!A:B,2,FALSE)-G58,-2))","v":0},{"$f":"ROUND(H58*VLOOKUP(B58*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"6"]
["ORT001",6,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P59,'FY23-FY24 Scales'!A:J,10,FALSE),G59)","v":0},{"$f":"IFERROR(VLOOKUP(P59,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G59*VLOOKUP(B59*1,'APU Scale'!A:B,2,FALSE)-G59,-2))","v":0},{"$f":"ROUND(H59*VLOOKUP(B59*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"6"]
["ORT001",6,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P60,'FY23-FY24 Scales'!A:J,10,FALSE),G60)","v":0},{"$f":"IFERROR(VLOOKUP(P60,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G60*VLOOKUP(B60*1,'APU Scale'!A:B,2,FALSE)-G60,-2))","v":0},{"$f":"ROUND(H60*VLOOKUP(B60*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"6"]
["ORT001",6,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P61,'FY23-FY24 Scales'!A:J,10,FALSE),G61)","v":0},{"$f":"IFERROR(VLOOKUP(P61,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G61*VLOOKUP(B61*1,'APU Scale'!A:B,2,FALSE)-G61,-2))","v":0},{"$f":"ROUND(H61*VLOOKUP(B61*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"6"]
["ORT001",6,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P62,'FY23-FY24 Scales'!A:J,10,FALSE),G62)","v":0},{"$f":"IFERROR(VLOOKUP(P62,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G62*VLOOKUP(B62*1,'APU Scale'!A:B,2,FALSE)-G62,-2))","v":0},{"$f":"ROUND(H62*VLOOKUP(B62*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"6"]
["ORT001",6,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P63,'FY23-FY24 Scales'!A:J,10,FALSE),G63)","v":0},{"$f":"IFERROR(VLOOKUP(P63,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G63*VLOOKUP(B63*1,'APU Scale'!A:B,2,FALSE)-G63,-2))","v":0},{"$f":"ROUND(H63*VLOOKUP(B63*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"6"]
["ORT001",6,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P64,'FY23-FY24 Scales'!A:J,10,FALSE),G64)","v":0},{"$f":"IFERROR(VLOOKUP(P64,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G64*VLOOKUP(B64*1,'APU Scale'!A:B,2,FALSE)-G64,-2))","v":0},{"$f":"ROUND(H64*VLOOKUP(B64*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"6"]
["ORT001",6,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P65,'FY23-FY24 Scales'!A:J,10,FALSE),G65)","v":0},{"$f":"IFERROR(VLOOKUP(P65,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G65*VLOOKUP(B65*1,'APU Scale'!A:B,2,FALSE)-G65,-2))","v":0},{"$f":"ROUND(H65*VLOOKUP(B65*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"6"]
["ORT001",6,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P66,'FY23-FY24 Scales'!A:J,10,FALSE),G66)","v":0},{"$f":"IFERROR(VLOOKUP(P66,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G66*VLOOKUP(B66*1,'APU Scale'!A:B,2,FALSE)-G66,-2))","v":0},{"$f":"ROUND(H66*VLOOKUP(B66*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"6"]
["ORT001",6,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P67,'FY23-FY24 Scales'!A:J,10,FALSE),G67)","v":0},{"$f":"IFERROR(VLOOKUP(P67,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G67*VLOOKUP(B67*1,'APU Scale'!A:B,2,FALSE)-G67,-2))","v":0},{"$f":"ROUND(H67*VLOOKUP(B67*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"6"]
["ORT001",6,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P68,'FY23-FY24 Scales'!A:J,10,FALSE),G68)","v":0},{"$f":"IFERROR(VLOOKUP(P68,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G68*VLOOKUP(B68*1,'APU Scale'!A:B,2,FALSE)-G68,-2))","v":0},{"$f":"ROUND(H68*VLOOKUP(B68*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"6"]
["ORT001",6,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P69,'FY23-FY24 Scales'!A:J,10,FALSE),G69)","v":0},{"$f":"IFERROR(VLOOKUP(P69,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G69*VLOOKUP(B69*1,'APU Scale'!A:B,2,FALSE)-G69,-2))","v":0},{"$f":"ROUND(H69*VLOOKUP(B69*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"6"]
["ORT001",6,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P70,'FY23-FY24 Scales'!A:J,10,FALSE),G70)","v":0},{"$f":"IFERROR(VLOOKUP(P70,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G70*VLOOKUP(B70*1,'APU Scale'!A:B,2,FALSE)-G70,-2))","v":0},{"$f":"ROUND(H70*VLOOKUP(B70*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"6"]
["ORT001",6,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P71,'FY23-FY24 Scales'!A:J,10,FALSE),G71)","v":0},{"$f":"IFERROR(VLOOKUP(P71,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G71*VLOOKUP(B71*1,'APU Scale'!A:B,2,FALSE)-G71,-2))","v":0},{"$f":"ROUND(H71*VLOOKUP(B71*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"6"]
["ORT001",6,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P72,'FY23-FY24 Scales'!A:J,10,FALSE),G72)","v":0},{"$f":"IFERROR(VLOOKUP(P72,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G72*VLOOKUP(B72*1,'APU Scale'!A:B,2,FALSE)-G72,-2))","v":0},{"$f":"ROUND(H72*VLOOKUP(B72*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"6"]
["ORT001",6,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P73,'FY23-FY24 Scales'!A:J,10,FALSE),G73)","v":0},{"$f":"IFERROR(VLOOKUP(P73,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G73*VLOOKUP(B73*1,'APU Scale'!A:B,2,FALSE)-G73,-2))","v":0},{"$f":"ROUND(H73*VLOOKUP(B73*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"6"]
["ORT001",6,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P74,'FY23-FY24 Scales'!A:J,10,FALSE),G74)","v":0},{"$f":"IFERROR(VLOOKUP(P74,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G74*VLOOKUP(B74*1,'APU Scale'!A:B,2,FALSE)-G74,-2))","v":0},{"$f":"ROUND(H74*VLOOKUP(B74*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},{"$f":"K74+L74+M74","v":0},{"$f":"IF(I74-J74-N74<0,0,I74-J74-N74)","v":0},{"$f":"CONCATENATE(E74,F74,B74)","v":"6"}]
[{"$f":"A74","v":"ORT001"},{"$f":"B74","v":6},null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P75,'FY23-FY24 Scales'!A:J,10,FALSE),G75)","v":0},{"$f":"IFERROR(VLOOKUP(P75,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G75*VLOOKUP(B75*1,'APU Scale'!A:B,2,FALSE)-G75,-2))","v":0},{"$f":"ROUND(H75*VLOOKUP(B75*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"6"]
["ORT001",6,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P76,'FY23-FY24 Scales'!A:J,10,FALSE),G76)","v":0},{"$f":"IFERROR(VLOOKUP(P76,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G76*VLOOKUP(B76*1,'APU Scale'!A:B,2,FALSE)-G76,-2))","v":0},{"$f":"ROUND(H76*VLOOKUP(B76*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"6"]
["ORT001",6,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P77,'FY23-FY24 Scales'!A:J,10,FALSE),G77)","v":0},{"$f":"IFERROR(VLOOKUP(P77,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G77*VLOOKUP(B77*1,'APU Scale'!A:B,2,FALSE)-G77,-2))","v":0},{"$f":"ROUND(H77*VLOOKUP(B77*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"6"]
["ORT001",6,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P78,'FY23-FY24 Scales'!A:J,10,FALSE),G78)","v":0},{"$f":"IFERROR(VLOOKUP(P78,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G78*VLOOKUP(B78*1,'APU Scale'!A:B,2,FALSE)-G78,-2))","v":0},{"$f":"ROUND(H78*VLOOKUP(B78*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"6"]
["ORT001",6,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P79,'FY23-FY24 Scales'!A:J,10,FALSE),G79)","v":0},{"$f":"IFERROR(VLOOKUP(P79,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G79*VLOOKUP(B79*1,'APU Scale'!A:B,2,FALSE)-G79,-2))","v":0},{"$f":"ROUND(H79*VLOOKUP(B79*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"6"]
["ORT001",6,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P80,'FY23-FY24 Scales'!A:J,10,FALSE),G80)","v":0},{"$f":"IFERROR(VLOOKUP(P80,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G80*VLOOKUP(B80*1,'APU Scale'!A:B,2,FALSE)-G80,-2))","v":0},{"$f":"ROUND(H80*VLOOKUP(B80*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"6"]
["ORT001",6,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P81,'FY23-FY24 Scales'!A:J,10,FALSE),G81)","v":0},{"$f":"IFERROR(VLOOKUP(P81,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G81*VLOOKUP(B81*1,'APU Scale'!A:B,2,FALSE)-G81,-2))","v":0},{"$f":"ROUND(H81*VLOOKUP(B81*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"6"]
["ORT001",6,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P82,'FY23-FY24 Scales'!A:J,10,FALSE),G82)","v":0},{"$f":"IFERROR(VLOOKUP(P82,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G82*VLOOKUP(B82*1,'APU Scale'!A:B,2,FALSE)-G82,-2))","v":0},{"$f":"ROUND(H82*VLOOKUP(B82*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"6"]
["ORT001",6,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P83,'FY23-FY24 Scales'!A:J,10,FALSE),G83)","v":0},{"$f":"IFERROR(VLOOKUP(P83,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G83*VLOOKUP(B83*1,'APU Scale'!A:B,2,FALSE)-G83,-2))","v":0},{"$f":"ROUND(H83*VLOOKUP(B83*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"6"]
["ORT001",6,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P84,'FY23-FY24 Scales'!A:J,10,FALSE),G84)","v":0},{"$f":"IFERROR(VLOOKUP(P84,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G84*VLOOKUP(B84*1,'APU Scale'!A:B,2,FALSE)-G84,-2))","v":0},{"$f":"ROUND(H84*VLOOKUP(B84*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"6"]
["ORT001",6,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P85,'FY23-FY24 Scales'!A:J,10,FALSE),G85)","v":0},{"$f":"IFERROR(VLOOKUP(P85,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G85*VLOOKUP(B85*1,'APU Scale'!A:B,2,FALSE)-G85,-2))","v":0},{"$f":"ROUND(H85*VLOOKUP(B85*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"6"]
["ORT001",6,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P86,'FY23-FY24 Scales'!A:J,10,FALSE),G86)","v":0},{"$f":"IFERROR(VLOOKUP(P86,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G86*VLOOKUP(B86*1,'APU Scale'!A:B,2,FALSE)-G86,-2))","v":0},{"$f":"ROUND(H86*VLOOKUP(B86*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"6"]
["ORT001",6,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P87,'FY23-FY24 Scales'!A:J,10,FALSE),G87)","v":0},{"$f":"IFERROR(VLOOKUP(P87,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G87*VLOOKUP(B87*1,'APU Scale'!A:B,2,FALSE)-G87,-2))","v":0},{"$f":"ROUND(H87*VLOOKUP(B87*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"6"]
["ORT001",6,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P88,'FY23-FY24 Scales'!A:J,10,FALSE),G88)","v":0},{"$f":"IFERROR(VLOOKUP(P88,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G88*VLOOKUP(B88*1,'APU Scale'!A:B,2,FALSE)-G88,-2))","v":0},{"$f":"ROUND(H88*VLOOKUP(B88*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"6"]
["ORT001",6,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P89,'FY23-FY24 Scales'!A:J,10,FALSE),G89)","v":0},{"$f":"IFERROR(VLOOKUP(P89,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G89*VLOOKUP(B89*1,'APU Scale'!A:B,2,FALSE)-G89,-2))","v":0},{"$f":"ROUND(H89*VLOOKUP(B89*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"6"]
["ORT001",6,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P90,'FY23-FY24 Scales'!A:J,10,FALSE),G90)","v":0},{"$f":"IFERROR(VLOOKUP(P90,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G90*VLOOKUP(B90*1,'APU Scale'!A:B,2,FALSE)-G90,-2))","v":0},{"$f":"ROUND(H90*VLOOKUP(B90*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"6"]
["ORT001",6,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P91,'FY23-FY24 Scales'!A:J,10,FALSE),G91)","v":0},{"$f":"IFERROR(VLOOKUP(P91,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G91*VLOOKUP(B91*1,'APU Scale'!A:B,2,FALSE)-G91,-2))","v":0},{"$f":"ROUND(H91*VLOOKUP(B91*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"6"]
["ORT001",6,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P92,'FY23-FY24 Scales'!A:J,10,FALSE),G92)","v":0},{"$f":"IFERROR(VLOOKUP(P92,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G92*VLOOKUP(B92*1,'APU Scale'!A:B,2,FALSE)-G92,-2))","v":0},{"$f":"ROUND(H92*VLOOKUP(B92*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"6"]
["ORT001",6,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P93,'FY23-FY24 Scales'!A:J,10,FALSE),G93)","v":0},{"$f":"IFERROR(VLOOKUP(P93,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G93*VLOOKUP(B93*1,'APU Scale'!A:B,2,FALSE)-G93,-2))","v":0},{"$f":"ROUND(H93*VLOOKUP(B93*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"6"]
["ORT001",6,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P94,'FY23-FY24 Scales'!A:J,10,FALSE),G94)","v":0},{"$f":"IFERROR(VLOOKUP(P94,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G94*VLOOKUP(B94*1,'APU Scale'!A:B,2,FALSE)-G94,-2))","v":0},{"$f":"ROUND(H94*VLOOKUP(B94*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"6"]
["ORT001",6,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P95,'FY23-FY24 Scales'!A:J,10,FALSE),G95)","v":0},{"$f":"IFERROR(VLOOKUP(P95,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G95*VLOOKUP(B95*1,'APU Scale'!A:B,2,FALSE)-G95,-2))","v":0},{"$f":"ROUND(H95*VLOOKUP(B95*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"6"]
["ORT001",6,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P96,'FY23-FY24 Scales'!A:J,10,FALSE),G96)","v":0},{"$f":"IFERROR(VLOOKUP(P96,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G96*VLOOKUP(B96*1,'APU Scale'!A:B,2,FALSE)-G96,-2))","v":0},{"$f":"ROUND(H96*VLOOKUP(B96*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"6"]
["ORT001",6,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P97,'FY23-FY24 Scales'!A:J,10,FALSE),G97)","v":0},{"$f":"IFERROR(VLOOKUP(P97,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G97*VLOOKUP(B97*1,'APU Scale'!A:B,2,FALSE)-G97,-2))","v":0},{"$f":"ROUND(H97*VLOOKUP(B97*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"6"]
["ORT001",6,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P98,'FY23-FY24 Scales'!A:J,10,FALSE),G98)","v":0},{"$f":"IFERROR(VLOOKUP(P98,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G98*VLOOKUP(B98*1,'APU Scale'!A:B,2,FALSE)-G98,-2))","v":0},{"$f":"ROUND(H98*VLOOKUP(B98*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"6"]
["ORT001",6,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P99,'FY23-FY24 Scales'!A:J,10,FALSE),G99)","v":0},{"$f":"IFERROR(VLOOKUP(P99,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G99*VLOOKUP(B99*1,'APU Scale'!A:B,2,FALSE)-G99,-2))","v":0},{"$f":"ROUND(H99*VLOOKUP(B99*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"6"]
["ORT001",6,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P100,'FY23-FY24 Scales'!A:J,10,FALSE),G100)","v":0},{"$f":"IFERROR(VLOOKUP(P100,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G100*VLOOKUP(B100*1,'APU Scale'!A:B,2,FALSE)-G100,-2))","v":0},{"$f":"ROUND(H100*VLOOKUP(B100*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"6"]
["ORT001",6,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P101,'FY23-FY24 Scales'!A:J,10,FALSE),G101)","v":0},{"$f":"IFERROR(VLOOKUP(P101,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G101*VLOOKUP(B101*1,'APU Scale'!A:B,2,FALSE)-G101,-2))","v":0},{"$f":"ROUND(H101*VLOOKUP(B101*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"6"]
["ORT001",6,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P102,'FY23-FY24 Scales'!A:J,10,FALSE),G102)","v":0},{"$f":"IFERROR(VLOOKUP(P102,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G102*VLOOKUP(B102*1,'APU Scale'!A:B,2,FALSE)-G102,-2))","v":0},{"$f":"ROUND(H102*VLOOKUP(B102*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"6"]
["ORT001",6,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P103,'FY23-FY24 Scales'!A:J,10,FALSE),G103)","v":0},{"$f":"IFERROR(VLOOKUP(P103,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G103*VLOOKUP(B103*1,'APU Scale'!A:B,2,FALSE)-G103,-2))","v":0},{"$f":"ROUND(H103*VLOOKUP(B103*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"6"]
["ORT001",6,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P104,'FY23-FY24 Scales'!A:J,10,FALSE),G104)","v":0},{"$f":"IFERROR(VLOOKUP(P104,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G104*VLOOKUP(B104*1,'APU Scale'!A:B,2,FALSE)-G104,-2))","v":0},{"$f":"ROUND(H104*VLOOKUP(B104*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"6"]
["ORT001",6,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P105,'FY23-FY24 Scales'!A:J,10,FALSE),G105)","v":0},{"$f":"IFERROR(VLOOKUP(P105,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G105*VLOOKUP(B105*1,'APU Scale'!A:B,2,FALSE)-G105,-2))","v":0},{"$f":"ROUND(H105*VLOOKUP(B105*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"6"]
["ORT001",6,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P106,'FY23-FY24 Scales'!A:J,10,FALSE),G106)","v":0},{"$f":"IFERROR(VLOOKUP(P106,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G106*VLOOKUP(B106*1,'APU Scale'!A:B,2,FALSE)-G106,-2))","v":0},{"$f":"ROUND(H106*VLOOKUP(B106*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},{"$f":"K106+L106+M106","v":0},{"$f":"IF(I106-J106-N106<0,0,I106-J106-N106)","v":0},{"$f":"CONCATENATE(E106,F106,B106)","v":"6"}]
[{"$f":"A106","v":"ORT001"},{"$f":"B106","v":6},null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P107,'FY23-FY24 Scales'!A:J,10,FALSE),G107)","v":0},{"$f":"IFERROR(VLOOKUP(P107,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G107*VLOOKUP(B107*1,'APU Scale'!A:B,2,FALSE)-G107,-2))","v":0},{"$f":"ROUND(H107*VLOOKUP(B107*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"6"]
["ORT001",6,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P108,'FY23-FY24 Scales'!A:J,10,FALSE),G108)","v":0},{"$f":"IFERROR(VLOOKUP(P108,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G108*VLOOKUP(B108*1,'APU Scale'!A:B,2,FALSE)-G108,-2))","v":0},{"$f":"ROUND(H108*VLOOKUP(B108*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"6"]
["ORT001",6,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P109,'FY23-FY24 Scales'!A:J,10,FALSE),G109)","v":0},{"$f":"IFERROR(VLOOKUP(P109,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G109*VLOOKUP(B109*1,'APU Scale'!A:B,2,FALSE)-G109,-2))","v":0},{"$f":"ROUND(H109*VLOOKUP(B109*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"6"]
["ORT001",6,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P110,'FY23-FY24 Scales'!A:J,10,FALSE),G110)","v":0},{"$f":"IFERROR(VLOOKUP(P110,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G110*VLOOKUP(B110*1,'APU Scale'!A:B,2,FALSE)-G110,-2))","v":0},{"$f":"ROUND(H110*VLOOKUP(B110*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"6"]
["ORT001",6,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P111,'FY23-FY24 Scales'!A:J,10,FALSE),G111)","v":0},{"$f":"IFERROR(VLOOKUP(P111,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G111*VLOOKUP(B111*1,'APU Scale'!A:B,2,FALSE)-G111,-2))","v":0},{"$f":"ROUND(H111*VLOOKUP(B111*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"6"]
["ORT001",6,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P112,'FY23-FY24 Scales'!A:J,10,FALSE),G112)","v":0},{"$f":"IFERROR(VLOOKUP(P112,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G112*VLOOKUP(B112*1,'APU Scale'!A:B,2,FALSE)-G112,-2))","v":0},{"$f":"ROUND(H112*VLOOKUP(B112*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"6"]
["ORT001",6,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P113,'FY23-FY24 Scales'!A:J,10,FALSE),G113)","v":0},{"$f":"IFERROR(VLOOKUP(P113,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G113*VLOOKUP(B113*1,'APU Scale'!A:B,2,FALSE)-G113,-2))","v":0},{"$f":"ROUND(H113*VLOOKUP(B113*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"6"]
["ORT001",6,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P114,'FY23-FY24 Scales'!A:J,10,FALSE),G114)","v":0},{"$f":"IFERROR(VLOOKUP(P114,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G114*VLOOKUP(B114*1,'APU Scale'!A:B,2,FALSE)-G114,-2))","v":0},{"$f":"ROUND(H114*VLOOKUP(B114*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"6"]
["ORT001",6,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P115,'FY23-FY24 Scales'!A:J,10,FALSE),G115)","v":0},{"$f":"IFERROR(VLOOKUP(P115,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G115*VLOOKUP(B115*1,'APU Scale'!A:B,2,FALSE)-G115,-2))","v":0},{"$f":"ROUND(H115*VLOOKUP(B115*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"6"]
["ORT001",6,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P116,'FY23-FY24 Scales'!A:J,10,FALSE),G116)","v":0},{"$f":"IFERROR(VLOOKUP(P116,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G116*VLOOKUP(B116*1,'APU Scale'!A:B,2,FALSE)-G116,-2))","v":0},{"$f":"ROUND(H116*VLOOKUP(B116*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"6"]
["ORT001",6,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P117,'FY23-FY24 Scales'!A:J,10,FALSE),G117)","v":0},{"$f":"IFERROR(VLOOKUP(P117,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G117*VLOOKUP(B117*1,'APU Scale'!A:B,2,FALSE)-G117,-2))","v":0},{"$f":"ROUND(H117*VLOOKUP(B117*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"6"]
["ORT001",6,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P118,'FY23-FY24 Scales'!A:J,10,FALSE),G118)","v":0},{"$f":"IFERROR(VLOOKUP(P118,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G118*VLOOKUP(B118*1,'APU Scale'!A:B,2,FALSE)-G118,-2))","v":0},{"$f":"ROUND(H118*VLOOKUP(B118*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"6"]
["ORT001",6,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P119,'FY23-FY24 Scales'!A:J,10,FALSE),G119)","v":0},{"$f":"IFERROR(VLOOKUP(P119,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G119*VLOOKUP(B119*1,'APU Scale'!A:B,2,FALSE)-G119,-2))","v":0},{"$f":"ROUND(H119*VLOOKUP(B119*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"6"]
["ORT001",6,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P120,'FY23-FY24 Scales'!A:J,10,FALSE),G120)","v":0},{"$f":"IFERROR(VLOOKUP(P120,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G120*VLOOKUP(B120*1,'APU Scale'!A:B,2,FALSE)-G120,-2))","v":0},{"$f":"ROUND(H120*VLOOKUP(B120*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"6"]
["ORT001",6,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P121,'FY23-FY24 Scales'!A:J,10,FALSE),G121)","v":0},{"$f":"IFERROR(VLOOKUP(P121,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G121*VLOOKUP(B121*1,'APU Scale'!A:B,2,FALSE)-G121,-2))","v":0},{"$f":"ROUND(H121*VLOOKUP(B121*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"6"]
["ORT001",6,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P122,'FY23-FY24 Scales'!A:J,10,FALSE),G122)","v":0},{"$f":"IFERROR(VLOOKUP(P122,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G122*VLOOKUP(B122*1,'APU Scale'!A:B,2,FALSE)-G122,-2))","v":0},{"$f":"ROUND(H122*VLOOKUP(B122*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"6"]
["ORT001",6,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P123,'FY23-FY24 Scales'!A:J,10,FALSE),G123)","v":0},{"$f":"IFERROR(VLOOKUP(P123,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G123*VLOOKUP(B123*1,'APU Scale'!A:B,2,FALSE)-G123,-2))","v":0},{"$f":"ROUND(H123*VLOOKUP(B123*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"6"]
["ORT001",6,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P124,'FY23-FY24 Scales'!A:J,10,FALSE),G124)","v":0},{"$f":"IFERROR(VLOOKUP(P124,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G124*VLOOKUP(B124*1,'APU Scale'!A:B,2,FALSE)-G124,-2))","v":0},{"$f":"ROUND(H124*VLOOKUP(B124*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"6"]
["ORT001",6,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P125,'FY23-FY24 Scales'!A:J,10,FALSE),G125)","v":0},{"$f":"IFERROR(VLOOKUP(P125,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G125*VLOOKUP(B125*1,'APU Scale'!A:B,2,FALSE)-G125,-2))","v":0},{"$f":"ROUND(H125*VLOOKUP(B125*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"6"]
["ORT001",6,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P126,'FY23-FY24 Scales'!A:J,10,FALSE),G126)","v":0},{"$f":"IFERROR(VLOOKUP(P126,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G126*VLOOKUP(B126*1,'APU Scale'!A:B,2,FALSE)-G126,-2))","v":0},{"$f":"ROUND(H126*VLOOKUP(B126*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"6"]
["ORT001",6,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P127,'FY23-FY24 Scales'!A:J,10,FALSE),G127)","v":0},{"$f":"IFERROR(VLOOKUP(P127,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G127*VLOOKUP(B127*1,'APU Scale'!A:B,2,FALSE)-G127,-2))","v":0},{"$f":"ROUND(H127*VLOOKUP(B127*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"6"]
["ORT001",6,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P128,'FY23-FY24 Scales'!A:J,10,FALSE),G128)","v":0},{"$f":"IFERROR(VLOOKUP(P128,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G128*VLOOKUP(B128*1,'APU Scale'!A:B,2,FALSE)-G128,-2))","v":0},{"$f":"ROUND(H128*VLOOKUP(B128*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"6"]
["ORT001",6,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P129,'FY23-FY24 Scales'!A:J,10,FALSE),G129)","v":0},{"$f":"IFERROR(VLOOKUP(P129,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G129*VLOOKUP(B129*1,'APU Scale'!A:B,2,FALSE)-G129,-2))","v":0},{"$f":"ROUND(H129*VLOOKUP(B129*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"6"]
["ORT001",6,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P130,'FY23-FY24 Scales'!A:J,10,FALSE),G130)","v":0},{"$f":"IFERROR(VLOOKUP(P130,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G130*VLOOKUP(B130*1,'APU Scale'!A:B,2,FALSE)-G130,-2))","v":0},{"$f":"ROUND(H130*VLOOKUP(B130*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"6"]
["ORT001",6,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P131,'FY23-FY24 Scales'!A:J,10,FALSE),G131)","v":0},{"$f":"IFERROR(VLOOKUP(P131,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G131*VLOOKUP(B131*1,'APU Scale'!A:B,2,FALSE)-G131,-2))","v":0},{"$f":"ROUND(H131*VLOOKUP(B131*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"6"]
["ORT001",6,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P132,'FY23-FY24 Scales'!A:J,10,FALSE),G132)","v":0},{"$f":"IFERROR(VLOOKUP(P132,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G132*VLOOKUP(B132*1,'APU Scale'!A:B,2,FALSE)-G132,-2))","v":0},{"$f":"ROUND(H132*VLOOKUP(B132*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"6"]
["ORT001",6,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P133,'FY23-FY24 Scales'!A:J,10,FALSE),G133)","v":0},{"$f":"IFERROR(VLOOKUP(P133,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G133*VLOOKUP(B133*1,'APU Scale'!A:B,2,FALSE)-G133,-2))","v":0},{"$f":"ROUND(H133*VLOOKUP(B133*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"6"]
["ORT001",6,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P134,'FY23-FY24 Scales'!A:J,10,FALSE),G134)","v":0},{"$f":"IFERROR(VLOOKUP(P134,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G134*VLOOKUP(B134*1,'APU Scale'!A:B,2,FALSE)-G134,-2))","v":0},{"$f":"ROUND(H134*VLOOKUP(B134*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"6"]
["ORT001",6,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P135,'FY23-FY24 Scales'!A:J,10,FALSE),G135)","v":0},{"$f":"IFERROR(VLOOKUP(P135,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G135*VLOOKUP(B135*1,'APU Scale'!A:B,2,FALSE)-G135,-2))","v":0},{"$f":"ROUND(H135*VLOOKUP(B135*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"6"]
["ORT001",6,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P136,'FY23-FY24 Scales'!A:J,10,FALSE),G136)","v":0},{"$f":"IFERROR(VLOOKUP(P136,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G136*VLOOKUP(B136*1,'APU Scale'!A:B,2,FALSE)-G136,-2))","v":0},{"$f":"ROUND(H136*VLOOKUP(B136*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"6"]
["ORT001",6,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P137,'FY23-FY24 Scales'!A:J,10,FALSE),G137)","v":0},{"$f":"IFERROR(VLOOKUP(P137,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G137*VLOOKUP(B137*1,'APU Scale'!A:B,2,FALSE)-G137,-2))","v":0},{"$f":"ROUND(H137*VLOOKUP(B137*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"6"]
["ORT001",6,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P138,'FY23-FY24 Scales'!A:J,10,FALSE),G138)","v":0},{"$f":"IFERROR(VLOOKUP(P138,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G138*VLOOKUP(B138*1,'APU Scale'!A:B,2,FALSE)-G138,-2))","v":0},{"$f":"ROUND(H138*VLOOKUP(B138*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},{"$f":"K138+L138+M138","v":0},{"$f":"IF(I138-J138-N138<0,0,I138-J138-N138)","v":0},"6"]
["ORT001",6,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(P139,'FY23-FY24 Scales'!A:J,10,FALSE),G139)","v":0},{"$f":"IFERROR(VLOOKUP(P139,'FY23-FY24 Scales'!A:K,11,FALSE),ROUND(G139*VLOOKUP(B139*1,'APU Scale'!A:B,2,FALSE)-G139,-2))","v":0},{"$f":"ROUND(H139*VLOOKUP(B139*1,'APU Scale'!A:B,2,FALSE),-2)","v":0},0,0,"6"]

{"sheet":"APU Master","index":3,"n_rows":98,"n_cols":5,"rows_kept":98,"cut":false,"hidden":true,"merged":[]}
["as of 6/28/24"]
["APU Master List"]
[]
["Department/School","APU Code","Scale","APU Name","APU Definition"]
["Anesthesiology","ANE001",5,"Anesthesiology Clinical Faculty","All clinical faculty members in department."]
["Anesthesiology","ANEGCP",1,"Anesthesiology Ph.D. Faculty","All Ph.D. faculty members in department."]
["Cellular & Molecular Medicine","CMM001",4,"Cellular & Molecular Medicine","Faculty with primary appointment in the Department of Cellular and Molecular Medicine."]
["Dermatology ","MED043",3,"Dermatology Clinical Faculty","Clinically active faculty members in the Division of Dermatology."]
["Dermatology ","PEDDER",7,"Dermatology  ","Faculty specializing in Pediatric Dermatology who hold M.D. degree"]
["Emergency Medicine","EMS001",7,"DEM Faculty Leadership (EMS)","All faculty board certified in Emergency Medicine with active clinical, teaching, and scholarly profiles and have current major administrative and academic leadership positions or responsibilities, and must be long term positions within the department (e.g., Chair, Vice Chair, etc.)."]
["Emergency Medicine","EMS002",6,"DEM Faculty (EMS)","Full-time EMS faculty carrying full clinical responsibility along with teaching and scholarly productivity requirements."]
["Emergency Medicine","EMS003",1,"DEM Research Faculty","All faculty in this APU are PhD researchers in the Dept of Emergency Medicine."]
["Family Medicine","FPM001",5,"Family Medicine Physician and Leadership Faculty","All department faculty with medical doctoral degree (e.g. MD, DO) and/or Vice Chairs and Division Chiefs with or without medical doctoral degree (e.g. MD, DO, PhD, PsyD)."]
["Family Medicine","FPM002",3,"Family Medicine Non-Physician Faculty","All department faculty with non-medical doctoral degrees (e.g. PhD, PsyD)."]
["Family Medicine","FPM003",5,"Family Medicine PACE Faculty","All department faculty who are PACE (Physician Assessment Clinical Ed) Program faculty directors."]
["Medicine","MED029",1,"Gastroenterology Research Faculty","Research faculty members in the Division of Gastroenterology without clinical duties.  Other Department research oriented faculty members without clinical duties may participate in this APU as well."]
["Medicine","MED031",3,"Genomics & Precision Medicine Faculty","Clinically active and Research faculty members in the Division of Genomics & Precision Medicine."]
["Medicine","MED041",3,"Bone Marrow Transplantation Faculty","Clinically active faculty members in the Division of Bone Marrow Transplant."]
["Medicine","MED042",3,"Cardiovascular Medicine Clinical & Research Faculty","Clinically active and Research faculty members in the Division of Cardiovascular Medicine."]
["Medicine","MED044",3,"Endocrinology/Metabolism Clinical & Research Faculty","Clinically active and Research faculty members in the Division of Endocrinology/Metabolism."]
["Medicine","MED045",3,"Gastroenterology/Hepatology Clinical & Research Faculty","Clinically  active and Research faculty members in the Division of Gastroenterology/Hepatology."]
["Medicine","MED046",3,"General Internal Medicine Clinical & Research Faculty","Clinically active and Research faculty members in the Division of General Internal Medicine."]
["Medicine","MED048",3,"Hematology/Oncology Clinical & Research Faculty","Clinically active and Research faculty members in the Division of Hematology/Oncology."]
["Medicine","MED049",3,"Hospital Medicine Clinical Faculty","Clinically active faculty members in the Division of Hospital Medicine."]
["Medicine","MED050",3,"Infectious Diseases Clinical & Research Faculty","Clinically active and Research faculty members in the Division of Infectious Diseases."]
["Medicine","MED051",3,"Nephrology Clinical & Research Faculty","Clinically active and Research faculty members in the Division of Nephrology."]
["Medicine","MED053",3,"Pulmonary Clinical & Research Faculty","Clinically active and Research faculty members in the Division of Pulmonary."]
["Medicine","MED054",3,"Rheumatology, Autoimmunity and Inflammation and Allergy and Immunology Faculty","Clinically active and Research faculty members in the Division of Rheumatology, Autoimmunity and Inflammation and the Division of Allergy and Immunology."]
["Medicine","MED055",3,"Owens Clinical & Research Faculty","Clinically active and Research faculty members in the Division Owens Clinic."]
["Medicine","MED056",7,"Endocrinology/Metabolism APU7","Board Certified Endocrinologists with Academic Senate membership in FTE or IR series who are eligible for 100% UCRP participation."]
["Medicine","MED074",3,"Geriatrics, Gerontology and Palliative Care Faculty","Clinically active and Research faculty members in the Division of Geriatrics, Gerontology and Palliative Care."]
["Medicine","MED076",5,"Department's Division Chief Faculty (present and former)","DOM faculty members assigned as Division Chiefs as well as Department leadership positions\nas assigned by the Chair Person. Effective FY24 membership in this APU is assigned for the\nduration of the leadership term."]
["Medicine","MED077",3,"Global Public Health Faculty","Clinically active and Research faculty members in the Division of Global Public Health."]
["Medicine","MED078",3,"Biomedical Informatics Clinical & Research Faculty","Clinically active and Research faculty members in the Division of Biomedical Informatics."]
["Medicine","MED079",3,"Regenerative Medicine Clinical & Research Faculty","Clinically active and Research faculty members in the Division of Regenerative Medicine."]
["Medicine","MED100",0,"DOM Non-Clinical APU0","PhD, non-licensed MD and/or PhD/MD faculty members in the DOM who are research oriented and without clinical duties. Similar research would include faculty members who investigate the patho-physiological and molecular basis of diseases."]
["Neurological Surgery","NSG001",9,"Neurological Surgery Clinical Faculty","Clinically active faculty members in the Department of Neurological Surgery"]
["Neurosciences","NEU001",1,"Neurosciences Basic Scientists","Ph.D.s in the Department of Neurosciences"]
["Neurosciences","NEU003",3,"Neurosciences Clinicians","M.D.s in the Department of Neurosciences"]
["Neurosciences","NEUCHR",6,"Neurosciences Chairs/Vice Chairs/ORU Directors","Chair, Vice Chair/Directors of ORUs or other major, large-scale projects in the Dept of Neurosciences."]
["OBGYN & Reproductive Sciences","RPR001",7,"Reproductive Medicine Clinical Faculty","Clinical faculty."]
["OBGYN & Reproductive Sciences","RPR003",3,"Reproductive Medicine Other PhD Faculty","Reproductive Medicine Other PhD Faculty"]
["OBGYN & Reproductive Sciences","RPR004",6,"Center Grant Directors, Co-Directors, Core Directors","All research Ph.D. faculty who are Directors, Co-Directors &/or Core Directors of a Center Grant."]
["Ophthalmology","OPH001",9,"Ophthalmology Surgical Clinical Faculty","Ophthalmology Surgical Clinical Faculty"]
["Ophthalmology","OPHGCP",2,"Ophthalmology Ph.D. Faculty","Academics spending 80% or more time on research & academics with a valid 2113 allowing for patient care activities in addition to their research."]
["Orthopaedic Surgery","ORT001",6,"Orthopaedics Clinical Faculty","UCSD Orthopaedic Surgery faculty whose primary function is adult clinical care surgeons. "]
["Orthopaedic Surgery","ORT002",3,"Ortho Surgery Research Faculty","Ph.D. and M.D. faculty whose primary function is research"]
["Orthopaedic Surgery","ORT004",6,"Ortho Surg Fac w/Vice Chair/Residency Directorship","Orthopaedic Surgery faculty holding title of Vice Chair or Residency Director & involved in the administration of the various missions of the department."]
["Orthopaedic Surgery","ORT005","8","Ortho Surg Children's Faculty","Orthopaedic Surgery faculty whose primary function is as pediatric surgeons with the majority (51% or more) of their time at Rady Children’s Hospital, associated clinics, and research labs."]
["Orthopaedic Surgery","ORT006",3,"Orthopaedic Surgery Non-Surgical Faculty ","UCSD Orthopaedic Surgery faculty whose primary function is the non-surgical care of patients at UCSD Medical Center and associated clinics. "]
["Pathology","PTH001",1,"Pathology Pre-Clinical Faculty","All preclinical faculty regardless of area of research."]
["Pathology","PTH002",2,"Faculty who teach or research veterinary medicine","Faculty will teach or research veterinary medicine, focus upon clinical &/or resident & graduate student instruction into comparative pathology & medicine."]
["Pathology","PTH003",4,"Pathology Clinically Active Faculty","All clinically active faculty regardless of subspecialty in Pathology."]
["Pathology","PTH004",5,"Executive Leadership Committee","Specific division heads, including clinical path, anatomic path, neuropathology & Vice Chair Res. Members of APU will have MD and PhD degrees. Exe Leadership Com will focus on advising Chair on clinical, res & education issues, develop & implement policy."]
["Pathology","PTH005",3,"Department Based Ph.D. Scientists","Ph.D. scientists who are engaged in substantial teaching activities for SOM, SSOP &/or graduate studies. Must teach 50 contact hours in SOM, SOP &/or grad school program core courses each 12 months."]
["Pediatrics","PEDCAR",7,"Cardiology & Gastroenterology","Clinically active faculty specializing in Pediatric Cardiology, Critical Care, Gastroenterology, Hepatology, and Nutrition"]
["Pediatrics","PEDEME",5,"Emergency Medicine, Infectious Diseases, Respiratory Medicine","Clinically active faculty specializing in Pediatric Emergency Medicine, Infectious Diseases, and Respiratory Medicine\n"]
["Pediatrics","PEDNEO",9,"Neonatology","Faculty who holds an M.D. or D.O. specializing in Pediatric Neonatology"]
["Pediatrics","PEDPED",3,"Pediatric Subspecialties","Clinically active faculty specializing in Pediatrics Allergy, Immunology, Rheumatology, Child Development, General Pediatrics, Adolescent Medicine, Newborn Nursery, Urgent Care, Endocrinology, Genetics, Genomics, Dysmorphology, Hematology/Oncology, Hospital Medicine, Nephrology and faculty who are performing significant leadership roles in cutting-edge and high priority programs areas in Genomics, Dysmorphology/Teratology, Stem Cells, Diabetes, and Host-Microbe Systems & Therapeutics.\n"]
["Pediatrics","PEDPHD",3,"PhD Faculty & Non-clinically Active MD Faculty","PhD and non‐clinically active MD faculty whose primary function is research"]
["Pharmacology","PHR000",0,"Other Research","This APU is reserved for those investigators without an extramurally funded independent research program* or those with less than a full FTE. Faculty who qualify for a higher APU can voluntarily choose to belong to a lower APU.\n\n*An investigator without an extramurally funded independent research program is one who does not serve as Principal Investigator on one or more active research grant or contract, or direct a project/core on a PPG."]
["Pharmacology","PHR001",1,"Teaching & Research Group II","Consists of faculty who have not participated in integrated research programs that insure continuous research activity and support mechanisms or faculty having heavy administrative commitments."]
["Pharmacology","PHR003",3,"Coordinated Research & Teaching Unit","Formed by faculty group who conduct coordinated research and teaching activities.  Activities include graduate student and fellow training, weekly research discussions, participation in centers and program projects supported for extended periods."]
["Pharmacology","PHR005",5,"Coordinated Research, Teaching, & Program Mgmt Unit","Participate in all activities of PHR003 plus creation, organization, management of major programs such as PPGs, MSTP, Superfund, Pharmacogenomics."]
["Psychiatry","PST000",0,"Base appointment","Reserved for investigators without active research programs."]
["Psychiatry","PST001",1,"Pre-Clinical & Basic Science Faculty","Preclinical researchers and clinician educators without patient contact."]
["Psychiatry","PST002",2,"PhD Clinical Faculty ","Non-medical doctoral degree (e.g., PhD, PsyD) with patient contact at UCSD or affiliate site."]
["Psychiatry","PST003",3,"MD or Externally Funded Faculty","1. Medical degree (e.g., MD, DO) with patient contact at UCSD or affiliate site; or \n2. Externally-funded project."]
["Psychiatry","PST004",4,"Faculty with Significant Administrative Functions","1. Significant administrative functions (e.g., Associate Vice Chair); or \n2. Training program lead role (e.g., T32 or R25)."]
["Psychiatry","PST005",5,"Faculty Directing Complex Programs","1. Major administrative functions (e.g., Vice Chair, Division Chief, ORU Director), or \n2. Major training program director role (e.g., Joint Doctoral Program in Clinical Psychology, Adult Residency Training), or\n3. Major, large-scale projects."]
["Psychiatry","PST006",6,"Faculty with Major Leadership Functions","1. Major, large-scale projects plus significant/major administrative functions, or\n2. Chair or Executive Vice Chair."]
["Radiation Medicine and Applied Sciences","RAO002",8,"Radiation Oncology Faculty (RAO)","Radiation Oncology Faculty"]
["Radiation Medicine and Applied Sciences","RAO005",5,"Radiation Oncology PhD Physicists (RAO)","Radiation Oncology Ph.D. Physicists"]
["Radiology","RAD001",8,"Diagnostic Division M.D. Faculty (RAD)","Diagnostic Division MDs."]
["Radiology","RAD003",2,"Diagnostic Division Ph.D. Faculty (RAD)","Diagnostic Division PhDs."]
["Radiology","RAD004",5,"Radiology fMRI Division Faculty","Radiology fMRI Division Faculty"]
["Radiology","RAD005",5,"Senior Research Imaging Faculty","Senior Research Imaging Faculty"]
["SOM School-Wide APUs","SOM001",6,"Academic Deans/Directors/Department Chairs","Current and former Chairs, Academic Deans, Assoc Deans, Assistant Deans, Directors of Institutionally Mandated ORUs or Institutionally Mandated Non-ORU Centers in Health Sciences previously designated as ORUs in Health Sciences & Directors appointed to Health Sciences mandated administrative roles."]
["SOM School-Wide APUs","SOM002",7,"Surgical Chairs","Leadership in Depts that have surgical procedures.  Currently OPH, ORT, RPR, SUR."]
["SOM School-Wide APUs","SOM003",3,"Cross Department Nerve Injury APU","Investigators dedicated to the restoration of functional losses due to nerve injury with NIH, UCSD and VA Healthcare System support."]
["SOM School-Wide APUs","SOM004",0,"Physician Assistant Program APU","Faculty in the Physician Assistant program."]
["SOM School-Wide APUs","SOM009",9,"HS Mission Leaders APU","Thought Leaders in education, research, and clinical missions responsible for the leadership in strategy of the mssions and provide the academic counsel on mission direction, development, and implementation of programs and initiatives, and accountability for the successes and failure of the primary missions of HS."]
["SOM School-Wide APUs","SOMVA1",0,"Base UC/VA split appointment APU","Base UC/VA split appointment School wide APU"]
["Surgery","SUR001",7,"General & Pediatric Surgery Division Faculty (SUR)","Faculty in the Division of General Surgery who belong to MSCCP."]
["Surgery","SUR002",9,"Cardiothoracic Surgery Division Faculty (SUR)","Faculty in the Division of Cardiothoracic Surgery who belong to MSCCP."]
["Surgery","SUR004",7,"Otolaryngology Division Faculty (SUR)","Faculty in the Division of Otolaryngology who belong to MSCCP."]
["Surgery","SUR005",7,"Plastic Surgery Division Faculty (SUR)","Faculty in the Division of Plastic Surgery who belong to MSCCP."]
["Surgery","SUR006",8,"Trauma/Burn Division Faculty (SUR)","Faculty in the Division of Trauma/Burn who belong to MSCCP."]
["Surgery","SUR008",1,"Surgery PhD and non-clinically active MD Faculty","Surgery PhD faculty and MD faculty who are engaged primarily in research and teaching without a clinical practice."]
["Urology","SUR007",7,"Urology Division Faculty (SUR)","Faculty in the Division of Urology who belong to MSCCP."]
["Herbert Wertheim School of Public Health and Human Longevity Science (HWSPH)","SPH000",0,"Basic Faculty APU","Faculty members in the HWSPH. L(P)SOE faculty.\n*** HWSPH faculty who qualify for a higher APU may voluntarily choose to belong to a lower APU."]
["Herbert Wertheim School of Public Health and Human Longevity Science (HWSPH)","SPH002",2,"Prior FMPH APU Faculty","Faculty with experience conducting public health research and/or teaching in a School of Medicine.\n*** HWSPH faculty who qualify for a higher APU may voluntarily choose to belong to a lower APU."]
["Herbert Wertheim School of Public Health and Human Longevity Science (HWSPH)","SPH003",3,"Public Health Research and Teaching Faculty","Faculty members in the HWSPH that lead or participate in funded research and/or teach in the School's degree programs.\n*** HWSPH faculty who qualify for a higher APU may voluntarily choose to belong to a lower APU."]
["Herbert Wertheim School of Public Health and Human Longevity Science (HWSPH)","SPH005",5,"School Leadership","Faculty who hold, or have held, a high‐level leadership position in the HWSPH including Division Chiefs and degree program Directors, which include a significant amount of administrative service supporting the School. At the discretion of the Dean, this APU may be extended to HWSPH faculty who hold similar level leadership positions elsewhere in Health Sciences or the University.\n*** HWSPH faculty who qualify for a higher APU may voluntarily choose to belong to a lower APU."]
["Herbert Wertheim School of Public Health and Human Longevity Science (HWSPH)","SPH006",6,"Assistant and Associate Deans, Dean","Faculty who hold, or have held, an Assistant Dean, Associate Dean, or Dean appointment in the HWSPH, which include a significant amount of administrative service supporting the School. At the discretion of the Dean, this APU may be extended to HWSPH faculty who hold senior leadership positions elsewhere in Health Sciences or the University such as Assisstant / Associate Vice Chancellor, Vice Chancellor, ORU Director.\n*** HWSPH faculty who qualify for a higher APU may voluntarily choose to belong to a lower APU."]
["Skaggs School of Pharmacy and Pharmaceutical Sciences","SOP001",6,"Assistant and Associate Deans, Dean","Must be an Assistant or Associate Dean in the Skaggs School of Pharmacy and Pharmaceutical Sciences who supports the teaching, research, clinical and community service missions of the University.  Activities include a large amount of administrative service supporting the School and the University.  SSPPS faculty who qualify for a higher APU may voluntarily choose to belong to a lower APU."]
["Skaggs School of Pharmacy and Pharmaceutical Sciences","SOP002",3,"SSPPS clinical + research + teaching","A faculty group in the Skaggs School of Pharmacy and Pharmaceutical Sciences (SSPPS) that conducts coordinated clinical (and/or patient care), and/or research and teaching activities.  These activities include training pharmacy, medical and graduate students in the classroom, research discussions and seminars, clinical research, clinical patient fairs, and work in the University free clinics and community clinics providing patient education and/or services, or being the PI on grants, and participation in centers and program projects.  SSPPS faculty who qualify for a higher APU may voluntarily choose to belong to a lower APU."]
["Skaggs School of Pharmacy and Pharmaceutical Sciences","SOP003",0,"Basic Faculty APU","A group of faculty members in the Skaggs School of Pharmacy & Pharmaceutical Sciences (SSPPS) who are research oriented and/or contribute a significant portion of their effort to the teaching mission.  SSPPS faculty who qualify for a higher APU may voluntarily choose to belong to a lower APU."]

{"sheet":"FY23-FY24 Scales","index":4,"n_rows":204,"n_cols":12,"rows_kept":204,"cut":false,"hidden":true,"merged":[]}
["USE THIS TO VERIFY the X, X', and covered comp"]
["* May want to replace \"Full\" with \"Full to match the APU profile"]
[]
["Concatenate (roman numero + user \"Full\" instead of \"Full\")","Step (roman numero)","Concatenate","APU","Rank","Step","07/01 X","07/01 X' actual","07/01 Covered Comp","10/01 X","10/01 X' actual","10/01 Covered Comp"]
[{"$f":"CONCATENATE(E5,B5,D5)","v":"AssistantI0"},{"$f":"ROMAN(F5)","v":"I"},{"$f":"CONCATENATE(E5,F5,D5)","v":"Assistant10"},0,"Assistant",1,82200,0,{"$f":"SUM(G5:H5)","v":82200},86500,0,{"$f":"SUM(J5:K5)","v":86500}]
[{"$f":"CONCATENATE(E6,B6,D6)","v":"AssistantII0"},{"$f":"ROMAN(F6)","v":"II"},{"$f":"CONCATENATE(E6,F6,D6)","v":"Assistant20"},0,"Assistant",2,87100,0,87100,91300,0,{"$f":"SUM(J6:K6)","v":91300}]
[{"$f":"CONCATENATE(E7,B7,D7)","v":"AssistantIII0"},"III","Assistant30",0,"Assistant",3,92100,0,92100,96400,0,96400]
["AssistantIV0","IV","Assistant40",0,"Assistant",4,97200,0,97200,101700,0,101700]
["AssistantV0","V","Assistant50",0,"Assistant",5,102400,0,102400,107200,0,107200]
["AssistantVI0","VI","Assistant60",0,"Assistant",6,107700,0,107700,112800,0,112800]
["AssociateI0","I","Associate10",0,"Associate",1,102500,0,102500,107300,0,107300]
["AssociateII0","II","Associate20",0,"Associate",2,107800,0,107800,112900,0,112900]
["AssociateIII0","III","Associate30",0,"Associate",3,113400,0,113400,118900,0,118900]
["AssociateIV0","IV","Associate40",0,"Associate",4,120100,0,120100,125600,0,125600]
["AssociateV0","V","Associate50",0,"Associate",5,129300,0,129300,135300,0,135300]
["FullI0","I","Full10",0,"Full",1,120200,0,120200,125700,0,125700]
["FullII0","II","Full20",0,"Full",2,129400,0,129400,135400,0,135400]
["FullIII0","III","Full30",0,"Full",3,139400,0,139400,145900,0,145900]
["FullIV0","IV","Full40",0,"Full",4,149900,0,149900,156900,0,156900]
["FullV0","V","Full50",0,"Full",5,161100,0,161100,168700,0,168700]
["FullVI0","VI","Full60",0,"Full",6,173200,0,173200,181200,0,181200]
["FullVII0","VII","Full70",0,"Full",7,186500,0,186500,195100,0,195100]
["FullVIII0","VIII","Full80",0,"Full",8,201600,0,201600,210900,0,210900]
["FullIX0","IX","Full90",0,"Full",9,218500,0,218500,228600,0,228600]
["AssistantI1","I","Assistant11",1,"Assistant",1,82200,8300,90500,86500,8700,95200]
["AssistantII1","II","Assistant21",1,"Assistant",2,87100,8800,95900,91300,9200,100500]
["AssistantIII1","III","Assistant31",1,"Assistant",3,92100,9300,101400,96400,9700,106100]
["AssistantIV1","IV","Assistant41",1,"Assistant",4,97200,9800,107000,101700,10200,111900]
["AssistantV1","V","Assistant51",1,"Assistant",5,102400,10300,112700,107200,10800,118000]
["AssistantVI1","VI","Assistant61",1,"Assistant",6,107700,10800,118500,112800,11300,124100]
["AssociateI1","I","Associate11",1,"Associate",1,102500,10300,112800,107300,10800,118100]
["AssociateII1","II","Associate21",1,"Associate",2,107800,10800,118600,112900,11300,124200]
["AssociateIII1","III","Associate31",1,"Associate",3,113400,11400,124800,118900,11900,130800]
["AssociateIV1","IV","Associate41",1,"Associate",4,120100,12100,132200,125600,12600,138200]
["AssociateV1","V","Associate51",1,"Associate",5,129300,13000,142300,135300,13600,148900]
["FullI1","I","Full11",1,"Full",1,120200,12100,132300,125700,12600,138300]
["FullII1","II","Full21",1,"Full",2,129400,13000,142400,135400,13600,149000]
["FullIII1","III","Full31",1,"Full",3,139400,14000,153400,145900,14600,160500]
["FullIV1","IV","Full41",1,"Full",4,149900,15000,164900,156900,15700,172600]
["FullV1","V","Full51",1,"Full",5,161100,16200,177300,168700,16900,185600]
["FullVI1","VI","Full61",1,"Full",6,173200,17400,190600,181200,18200,199400]
["FullVII1","VII","Full71",1,"Full",7,186500,18700,205200,195100,19600,214700]
["FullVIII1","VIII","Full81",1,"Full",8,201600,20200,221800,210900,21100,232000]
["FullIX1","IX","Full91",1,"Full",9,218500,21900,240400,228600,22900,251500]
["AssistantI2","I","Assistant12",2,"Assistant",1,82200,16500,98700,86500,17300,103800]
["AssistantII2","II","Assistant22",2,"Assistant",2,87100,17500,104600,91300,18300,109600]
["AssistantIII2","III","Assistant32",2,"Assistant",3,92100,18500,110600,96400,19300,115700]
["AssistantIV2","IV","Assistant42",2,"Assistant",4,97200,19500,116700,101700,20400,122100]
["AssistantV2","V","Assistant52",2,"Assistant",5,102400,20500,122900,107200,21500,128700]
["AssistantVI2","VI","Assistant62",2,"Assistant",6,107700,21600,129300,112800,22600,135400]
["AssociateI2","I","Associate12",2,"Associate",1,102500,20500,123000,107300,21500,128800]
["AssociateII2","II","Associate22",2,"Associate",2,107800,21600,129400,112900,22600,135500]
["AssociateIII2","III","Associate32",2,"Associate",3,113400,22700,136100,118900,23800,142700]
["AssociateIV2","IV","Associate42",2,"Associate",4,120100,24100,144200,125600,25200,150800]
["AssociateV2","V","Associate52",2,"Associate",5,129300,25900,155200,135300,27100,162400]
["FullI2","I","Full12",2,"Full",1,120200,24100,144300,125700,25200,150900]
["FullII2","II","Full22",2,"Full",2,129400,25900,155300,135400,27100,162500]
["FullIII2","III","Full32",2,"Full",3,139400,27900,167300,145900,29200,175100]
["FullIV2","IV","Full42",2,"Full",4,149900,30000,179900,156900,31400,188300]
["FullV2","V","Full52",2,"Full",5,161100,32300,193400,168700,33800,202500]
["FullVI2","VI","Full62",2,"Full",6,173200,34700,207900,181200,36300,217500]
["FullVII2","VII","Full72",2,"Full",7,186500,37300,223800,195100,39100,234200]
["FullVIII2","VIII","Full82",2,"Full",8,201600,40400,242000,210900,42200,253100]
["FullIX2","IX","Full92",2,"Full",9,218500,43700,262200,228600,45800,274400]
["AssistantI3","I","Assistant13",3,"Assistant",1,82200,24700,106900,86500,26000,112500]
["AssistantII3","II","Assistant23",3,"Assistant",2,87100,26200,113300,91300,27400,118700]
["AssistantIII3","III","Assistant33",3,"Assistant",3,92100,27700,119800,96400,29000,125400]
["AssistantIV3","IV","Assistant43",3,"Assistant",4,97200,29200,126400,101700,30600,132300]
["AssistantV3","V","Assistant53",3,"Assistant",5,102400,30800,{"$f":"SUM(G69:H69)","v":133200},107200,32200,139400]
["AssistantVI3",{"$f":"ROMAN(F70)","v":"VI"},{"$f":"CONCATENATE(E70,F70,D70)","v":"Assistant63"},3,"Assistant",6,107700,32400,140100,112800,33900,{"$f":"SUM(J70:K70)","v":146700}]
[{"$f":"CONCATENATE(E71,B71,D71)","v":"AssociateI3"},"I","Associate13",3,"Associate",1,102500,30800,133300,107300,32200,139500]
["AssociateII3","II","Associate23",3,"Associate",2,107800,32400,140200,112900,33900,146800]
["AssociateIII3","III","Associate33",3,"Associate",3,113400,34100,147500,118900,35700,154600]
["AssociateIV3","IV","Associate43",3,"Associate",4,120100,36100,156200,125600,37800,163400]
["AssociateV3","V","Associate53",3,"Associate",5,129300,38900,168200,135300,40700,176000]
["FullI3","I","Full13",3,"Full",1,120200,36100,156300,125700,37800,163500]
["FullII3","II","Full23",3,"Full",2,129400,38900,168300,135400,40700,176100]
["FullIII3","III","Full33",3,"Full",3,139400,41900,181300,145900,43800,189700]
["FullIV3","IV","Full43",3,"Full",4,149900,45000,194900,156900,47100,204000]
["FullV3","V","Full53",3,"Full",5,161100,48400,209500,168700,50700,219400]
["FullVI3","VI","Full63",3,"Full",6,173200,52000,225200,181200,54400,235600]
["FullVII3","VII","Full73",3,"Full",7,186500,56000,242500,195100,58600,253700]
["FullVIII3","VIII","Full83",3,"Full",8,201600,60500,262100,210900,63300,274200]
["FullIX3","IX","Full93",3,"Full",9,218500,65600,284100,228600,68600,297200]
["AssistantI4","I","Assistant14",4,"Assistant",1,82200,32900,115100,86500,34600,121100]
["AssistantII4","II","Assistant24",4,"Assistant",2,87100,34900,122000,91300,36600,127900]
["AssistantIII4","III","Assistant34",4,"Assistant",3,92100,36900,129000,96400,38600,135000]
["AssistantIV4","IV","Assistant44",4,"Assistant",4,97200,38900,136100,101700,40700,142400]
["AssistantV4","V","Assistant54",4,"Assistant",5,102400,41000,143400,107200,43000,150200]
["AssistantVI4","VI","Assistant64",4,"Assistant",6,107700,43200,150900,112800,45200,158000]
["AssociateI4","I","Associate14",4,"Associate",1,102500,41000,143500,107300,43000,150300]
["AssociateII4","II","Associate24",4,"Associate",2,107800,43200,151000,112900,45200,158100]
["AssociateIII4","III","Associate34",4,"Associate",3,113400,45400,158800,118900,47600,166500]
["AssociateIV4","IV","Associate44",4,"Associate",4,120100,48100,168200,125600,50300,175900]
["AssociateV4","V","Associate54",4,"Associate",5,129300,51800,181100,135300,54200,189500]
["FullI4","I","Full14",4,"Full",1,120200,48100,168300,125700,50300,176000]
["FullII4","II","Full24",4,"Full",2,129400,51800,181200,135400,54200,189600]
["FullIII4","III","Full34",4,"Full",3,139400,55800,195200,145900,58400,204300]
["FullIV4","IV","Full44",4,"Full",4,149900,60000,209900,156900,62800,219700]
["FullV4","V","Full54",4,"Full",5,161100,64500,225600,168700,67500,236200]
["FullVI4","VI","Full64",4,"Full",6,173200,69300,242500,181200,72500,253700]
["FullVII4","VII","Full74",4,"Full",7,186500,74600,261100,195100,78100,273200]
["FullVIII4","VIII","Full84",4,"Full",8,201600,80700,282300,210900,84400,295300]
["FullIX4","IX","Full94",4,"Full",9,218500,87400,305900,228600,91500,320100]
["AssistantI5","I","Assistant15",5,"Assistant",1,82200,41100,123300,86500,43300,129800]
["AssistantII5","II","Assistant25",5,"Assistant",2,87100,43600,130700,91300,45700,137000]
["AssistantIII5","III","Assistant35",5,"Assistant",3,92100,46100,138200,96400,48200,144600]
["AssistantIV5","IV","Assistant45",5,"Assistant",4,97200,48600,145800,101700,50900,152600]
["AssistantV5","V","Assistant55",5,"Assistant",5,102400,51300,153700,107200,53700,160900]
["AssistantVI5","VI","Assistant65",5,"Assistant",6,107700,53900,161600,112800,56500,169300]
["AssociateI5","I","Associate15",5,"Associate",1,102500,51300,153800,107300,53700,161000]
["AssociateII5","II","Associate25",5,"Associate",2,107800,53900,161700,112900,56500,169400]
["AssociateIII5","III","Associate35",5,"Associate",3,113400,56700,170100,118900,59500,178400]
["AssociateIV5","IV","Associate45",5,"Associate",4,120100,60100,180200,125600,62900,188500]
["AssociateV5","V","Associate55",5,"Associate",5,129300,64700,194000,135300,67700,203000]
["FullI5","I","Full15",5,"Full",1,120200,60100,180300,125700,62900,188600]
["FullII5","II","Full25",5,"Full",2,129400,64700,194100,135400,67700,203100]
["FullIII5","III","Full35",5,"Full",3,139400,69700,209100,145900,73000,218900]
["FullIV5","IV","Full45",5,"Full",4,149900,75000,224900,156900,78500,235400]
["FullV5","V","Full55",5,"Full",5,161100,80600,241700,168700,84400,253100]
["FullVI5","VI","Full65",5,"Full",6,173200,86600,259800,181200,90600,271800]
["FullVII5","VII","Full75",5,"Full",7,186500,93300,279800,195100,97600,292700]
["FullVIII5","VIII","Full85",5,"Full",8,201600,100800,302400,210900,105500,316400]
["FullIX5","IX","Full95",5,"Full",9,218500,109300,327800,228600,114300,342900]
["AssistantI6","I","Assistant16",6,"Assistant",1,82200,53500,135700,86500,56300,142800]
["AssistantII6","II","Assistant26",6,"Assistant",2,87100,56700,143800,91300,59400,150700]
["AssistantIII6","III","Assistant36",6,"Assistant",3,92100,59900,152000,96400,62700,159100]
["AssistantIV6","IV","Assistant46",6,"Assistant",4,97200,63200,160400,101700,66200,167900]
["AssistantV6","V","Assistant56",6,"Assistant",5,102400,66700,169100,107200,69800,177000]
["AssistantVI6","VI","Assistant66",6,"Assistant",6,107700,70100,177800,112800,73400,186200]
["AssociateI6","I","Associate16",6,"Associate",1,102500,66700,169200,107300,69800,177100]
["AssociateII6","II","Associate26",6,"Associate",2,107800,70100,177900,112900,73400,186300]
["AssociateIII6","III","Associate36",6,"Associate",3,113400,73800,{"$f":"SUM(G133:H133)","v":187200},118900,77300,196200]
["AssociateIV6",{"$f":"ROMAN(F134)","v":"IV"},{"$f":"CONCATENATE(E134,F134,D134)","v":"Associate46"},6,"Associate",4,120100,78200,198300,125600,81800,{"$f":"SUM(J134:K134)","v":207400}]
[{"$f":"CONCATENATE(E135,B135,D135)","v":"AssociateV6"},"V","Associate56",6,"Associate",5,129300,84200,213500,135300,88100,223400]
["FullI6","I","Full16",6,"Full",1,120200,78200,198400,125700,81800,207500]
["FullII6","II","Full26",6,"Full",2,129400,84200,213600,135400,88100,223500]
["FullIII6","III","Full36",6,"Full",3,139400,90700,230100,145900,94900,240800]
["FullIV6","IV","Full46",6,"Full",4,149900,97500,247400,156900,102000,258900]
["FullV6","V","Full56",6,"Full",5,161100,104800,265900,168700,109700,278400]
["FullVI6","VI","Full66",6,"Full",6,173200,112600,285800,181200,117800,299000]
["FullVII6","VII","Full76",6,"Full",7,186500,121300,307800,195100,126900,322000]
["FullVIII6","VIII","Full86",6,"Full",8,201600,131100,332700,210900,137100,348000]
["FullIX6","IX","Full96",6,"Full",9,218500,142100,360600,228600,148600,377200]
["AssistantI7","I","Assistant17",7,"Assistant",1,82200,65800,148000,86500,69200,155700]
["AssistantII7","II","Assistant27",7,"Assistant",2,87100,69700,156800,91300,73100,164400]
["AssistantIII7","III","Assistant37",7,"Assistant",3,92100,73700,165800,96400,77200,173600]
["AssistantIV7","IV","Assistant47",7,"Assistant",4,97200,77800,175000,101700,81400,183100]
["AssistantV7","V","Assistant57",7,"Assistant",5,102400,82000,184400,107200,85900,193100]
["AssistantVI7","VI","Assistant67",7,"Assistant",6,107700,86300,194000,112800,90400,203200]
["AssociateI7","I","Associate17",7,"Associate",1,102500,82000,184500,107300,85900,193200]
["AssociateII7","II","Associate27",7,"Associate",2,107800,86300,194100,112900,90400,203300]
["AssociateIII7","III","Associate37",7,"Associate",3,113400,90800,204200,118900,95200,214100]
["AssociateIV7","IV","Associate47",7,"Associate",4,120100,96200,216300,125600,100600,226200]
["AssociateV7","V","Associate57",7,"Associate",5,129300,103600,232900,135300,108400,243700]
["FullI7","I","Full17",7,"Full",1,120200,96200,216400,125700,100600,226300]
["FullII7","II","Full27",7,"Full",2,129400,103600,233000,135400,108400,243800]
["FullIII7","III","Full37",7,"Full",3,139400,111600,251000,145900,116800,262700]
["FullIV7","IV","Full47",7,"Full",4,149900,120000,269900,156900,125600,282500]
["FullV7","V","Full57",7,"Full",5,161100,128900,290000,168700,135000,303700]
["FullVI7","VI","Full67",7,"Full",6,173200,138600,311800,181200,145000,326200]
["FullVII7","VII","Full77",7,"Full",7,186500,149200,335700,195100,156100,351200]
["FullVIII7","VIII","Full87",7,"Full",8,201600,161300,362900,210900,168800,379700]
["FullIX7","IX","Full97",7,"Full",9,218500,174800,393300,228600,182900,411500]
["AssistantI8","I","Assistant18",8,"Assistant",1,82200,82200,164400,86500,86500,173000]
["AssistantII8","II","Assistant28",8,"Assistant",2,87100,87100,174200,91300,91300,182600]
["AssistantIII8","III","Assistant38",8,"Assistant",3,92100,92100,184200,96400,96400,192800]
["AssistantIV8","IV","Assistant48",8,"Assistant",4,97200,97200,194400,101700,101700,203400]
["AssistantV8","V","Assistant58",8,"Assistant",5,102400,102500,204900,107200,107300,214500]
["AssistantVI8","VI","Assistant68",8,"Assistant",6,107700,107800,215500,112800,112900,225700]
["AssociateI8","I","Associate18",8,"Associate",1,102500,102500,205000,107300,107300,214600]
["AssociateII8","II","Associate28",8,"Associate",2,107800,107800,215600,112900,112900,225800]
["AssociateIII8","III","Associate38",8,"Associate",3,113400,113400,226800,118900,118900,237800]
["AssociateIV8","IV","Associate48",8,"Associate",4,120100,120200,240300,125600,125700,251300]
["AssociateV8","V","Associate58",8,"Associate",5,129300,129400,258700,135300,135400,270700]
["FullI8","I","Full18",8,"Full",1,120200,120200,240400,125700,125700,251400]
["FullII8","II","Full28",8,"Full",2,129400,129400,258800,135400,135400,270800]
["FullIII8","III","Full38",8,"Full",3,139400,139400,278800,145900,145900,291800]
["FullIV8","IV","Full48",8,"Full",4,149900,149900,299800,156900,156900,313800]
["FullV8","V","Full58",8,"Full",5,161100,161100,322200,168700,168700,337400]
["FullVI8","VI","Full68",8,"Full",6,173200,173200,346400,181200,181200,362400]
["FullVII8","VII","Full78",8,"Full",7,186500,186500,373000,195100,195100,390200]
["FullVIII8","VIII","Full88",8,"Full",8,201600,201600,403200,210900,210900,421800]
["FullIX8","IX","Full98",8,"Full",9,218500,218500,437000,228600,228600,457200]
["AssistantI9","I","Assistant19",9,"Assistant",1,82200,102800,185000,86500,108200,194700]
["AssistantII9","II","Assistant29",9,"Assistant",2,87100,108900,196000,91300,114200,205500]
["AssistantIII9","III","Assistant39",9,"Assistant",3,92100,115200,207300,96400,120500,216900]
["AssistantIV9","IV","Assistant49",9,"Assistant",4,97200,121500,218700,101700,127200,228900]
["AssistantV9","V","Assistant59",9,"Assistant",5,102400,128200,230600,107200,134200,241400]
["AssistantVI9","VI","Assistant69",9,"Assistant",6,107700,134800,242500,112800,141200,254000]
["AssociateI9","I","Associate19",9,"Associate",1,102500,128200,230700,107300,134200,241500]
["AssociateII9","II","Associate29",9,"Associate",2,107800,134800,242600,112900,141200,254100]
["AssociateIII9","III","Associate39",9,"Associate",3,113400,141800,255200,118900,148700,267600]
["AssociateIV9","IV","Associate49",9,"Associate",4,120100,150300,270400,125600,157200,282800]
["AssociateV9","V","Associate59",9,"Associate",5,129300,161800,291100,135300,169300,304600]
["FullI9","I","Full19",9,"Full",1,120200,150300,270500,125700,157200,282900]
["FullII9","II","Full29",9,"Full",2,129400,161800,{"$f":"SUM(G197:H197)","v":291200},135400,169300,304700]
["FullIII9",{"$f":"ROMAN(F198)","v":"III"},{"$f":"CONCATENATE(E198,F198,D198)","v":"Full39"},9,"Full",3,139400,174300,313700,145900,182400,{"$f":"SUM(J198:K198)","v":328300}]
[{"$f":"CONCATENATE(E199,B199,D199)","v":"FullIV9"},"IV","Full49",9,"Full",4,149900,187400,337300,156900,196200,353100]
["FullV9","V","Full59",9,"Full",5,161100,201400,362500,168700,210900,379600]
["FullVI9","VI","Full69",9,"Full",6,173200,216500,389700,181200,226500,407700]
["FullVII9","VII","Full79",9,"Full",7,186500,233200,419700,195100,243900,439000]
["FullVIII9","VIII","Full89",9,"Full",8,201600,252000,453600,210900,263700,474600]
["FullIX9","IX","Full99",9,"Full",9,218500,273200,491700,228600,285800,514400]

{"sheet":"APU Scale","index":5,"n_rows":11,"n_cols":2,"rows_kept":11,"cut":false,"hidden":true,"merged":[]}
["Scale","Multiplier"]
[0,1]
[1,1.1000000000000001]
[2,1.2]
[3,1.3]
[4,1.4]
[5,1.5]
[6,1.65]
[7,1.8]
[8,2]
[9,2.25]